1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | SELECT A.DEPT_CODE , A.DEPT_NAME , A.P_DEPT_CODE , A.DEPT_SEQ , A.DEPT_LV , B.USER_NAME , B.USER_ID FROM ( SELECT DEPT_CODE , LPAD( ' ' , 4*( LEVEL -1)) || DEPT_NAME AS DEPT_NAME , P_DEPT_CODE , SEQ AS DEPT_SEQ , LEVEL AS DEPT_LV FROM DEPT START WITH PAR_ID = '000000101' CONNECT BY PRIOR DEPT_CODE = DECODE(DEPT_CODE, '000000101' , NULL , P_DEPT_CODE) ORDER SIBLINGS BY DEPT_SEQ ASC ) A , USER B WHERE A.DEPT_CODE = B.DEPT_CODE |