1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| WITH emp AS (SELECT 7369 empno, 'SMITH' ename, 7902 mgr FROM dual
UNION ALL SELECT 4799 empno, 'ALLEN' ename, 7698 mgr FROM dual
UNION ALL SELECT 7521 empno, 'WARD' ename, 7698 mgr FROM dual
UNION ALL SELECT 7566 empno, 'JONES' ename, 7839 mgr FROM dual
UNION ALL SELECT 7654 empno, 'MARTIN' ename, 7698 mgr FROM dual
UNION ALL SELECT 7698 empno, 'BLAKE' ename, 7839 mgr FROM dual
UNION ALL SELECT 7782 empno, 'CLARK' ename, 7839 mgr FROM dual
UNION ALL SELECT 7788 empno, 'SCOTT' ename, 7566 mgr FROM dual
UNION ALL SELECT 7839 empno, 'KING' ename, NULL mgr FROM dual
UNION ALL SELECT 7844 empno, 'TURNER' ename, 7698 mgr FROM dual
UNION ALL SELECT 7876 empno, 'ADAMS' ename, 7788 mgr FROM dual
UNION ALL SELECT 7900 empno, 'JAMES' ename, 7698 mgr FROM dual
UNION ALL SELECT 7902 empno, 'FORD' ename, 7566 mgr FROM dual
UNION ALL SELECT 7937 empno, 'MILLER' ename, 7782 mgr FROM dual)
SELECT m.*, e.*
FROM EMP m, EMP e
WHERE m.empno = e.mgr (+)
ORDER BY m.empno, e.empno |
Partager