SELECT DEPT_CD, UP_DEPT_CD, SYS_CONNECT_BY_PATH('DEPT_CD, '/') PATH
FROM 부서
WHERE COMPANY_CD = '1000'
START WITH COMPANY_CD = '1000' AND DEPT_CD = '301062'
CONNECT BY PRIOR UP_DEPT_CD = DEPT_CD
이 쿼리를 돌리면
DEPT_CD | UP_DEPT_CD | PATH |
100001 | /301062/200252/100001 | |
100012 | /301062/200252/100012 | |
100025 | /301062/200252/100025 | |
100028 | /301062/200252/100028 | |
100032 | /301062/200252/100032 | |
200252 | 100032 | /301062/200252 |
301062 | 200252 | /301062 |
이렇게 나오는데 100001, 100012,100025,100028은 왜나오는건지 모르겠어요ㅠㅠㅠㅠ