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;