Oracle 删除除了指定的主键值外的其他数据
DELETE FROM EMP E
WHERE E.EMPNO NOT IN (SELECT EMPNO
FROM EMP
WHERE EMPNO = 7369
OR EMPNO = 7499
OR EMPNO = 7521
OR EMPNO = 7566
OR EMPNO = 7654
OR EMPNO = 7698
OR EMPNO = 7782
OR EMPNO = 7788
OR EMPNO = 7839
OR EMPNO = 7844
OR EMPNO = 7876
OR EMPNO = 7900
OR EMPNO = 7902
OR EMPNO = 7934);