SELECT A.EMPLOYEE_ID, A.FIRST_NAME, A.MANAGER_ID,

B.EMPLOYEE_ID, B.FIRST_NAME, B.MANAGER_ID

FROM EMPLOYEES A, EMPLOYEES B

WHERE A.MANAGER_ID = B.EMPLOYEE_ID;



SELECT A.EMPLOYEE_ID, A.FIRST_NAME, A.MANAGER_ID

FROM EMPLOYEES A

START WITH A.MANAGER_ID IS NOT NULL

CONNECT BY PRIOR A.MANAGER_ID = B.EMPLOYEE_ID;

'Oracle' 카테고리의 다른 글

튜닝 기본  (0) 2017.03.23
실행계획  (0) 2017.03.06
OVER PARTITION BY  (0) 2017.02.22
EXISTS  (0) 2017.02.21
EXPLAIN PLAN FOR  (0) 2017.02.20

+ Recent posts