oracle中in，not in和exists，not exists之间的区别
存在测试IN、NOT IN、EXISTS、NOT EXISTS例：SELECT * FROM SC WHERE SNO IN (SELECT SNO FROM STUDENT WHERE SSEX=’女’);同：SELECT * FROM SC WHERE EXISTS (SELECT * FROM STUDENT WHERE SSEX=’女’ AND SC.SNO=SNO);
