17,382
社区成员




SQL> SELECT D.DEPTNO,E.EMPNO,E.ENAME,E.JOB,E.HIREDATE,E.SAL
2 FROM
3 DEPT D,EMP E
4 WHERE D.DEPTNO=E.DEPTNO(+);--显示dept表中的deptno即使在emp中没有
DEPTNO EMPNO ENAME JOB HIREDATE SAL
---------- ---------- ---------- --------- -------------- ----------
10 7782 CLARK MANAGER 09-6月 -81 2450
10 7839 KING PRESIDENT 17-11月-81 5000
10 7934 MILLER CLERK 23-1月 -82 1300
20 7369 SMITH CLERK 17-12月-80 800
20 7566 JONES MANAGER 02-4月 -81 2975
20 7788 SCOTT ANALYST 19-4月 -87 3000
20 7876 ADAMS CLERK 23-5月 -87 1100
20 7902 FORD ANALYST 03-12月-81 3000
30 7499 ALLEN SALESMAN 20-2月 -81 1600
30 7521 WARD SALESMAN 22-2月 -81 1250
30 7654 MARTIN SALESMAN 28-9月 -81 1250
DEPTNO EMPNO ENAME JOB HIREDATE SAL
---------- ---------- ---------- --------- -------------- ----------
30 7698 BLAKE MANAGER 01-5月 -81 2850
30 7844 TURNER SALESMAN 08-9月 -81 1500
30 7900 JAMES CLERK 03-12月-81 950
40