[ORACLE] 계층형 구조에서 최하위 항목 출력

SELECT *FROM DEPT_INFOWHERE CONNECT_BY_ISLEAF = 1 AND CONNECT_BY_ISCYCLE = 0START WITH PARNTS_DEPT_CD = '00000000'CONNECT BY NOCYCLE PRIOR DEPT_CD = PARNTS_DEPT_CD;

2018.10.26