SQL> conn scott/tiger
已连接。
SQL> select dname from dept
2 where not exists(select * from emp where deptno=dept.deptno)
3 /
DNAME
--------------
OPERATIONS
SQL> select d.dname from dept d left outer join emp e
2 on d.deptno=e.deptno
3 where e.empno is null
4 /
DNAME
--------------
OPERATIONS
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/37724/viewspace-152653/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/37724/viewspace-152653/