Oracle--NOT EXISTS 与 NOT IN 的区别
11g之后的oracle版本。一致的状况:存在性判断的话,不影响结果。CREATE TABLE students (ID NUMBER ,NAME VARCHAR2(20))CREATE TABLE lesson (ID NUMBER ,kc VARCHAR2(20))TRUNCATE TABLE studentsINSERT INTO students VALUES (...