develog

[Oracle] SYS_CONNECT_BY_PATH 본문

DB/Oracle

[Oracle] SYS_CONNECT_BY_PATH

냐옴 2016. 6. 20. 10:05

 

SELECT
	SYS_CONNECT_BY_PATH(CODE_NM, '/') PATH,
	A.*
FROM TB_CODE A
WHERE USE_YN = 1
START WITH CODE_SEQ = 1
CONNECT BY PRIOR CODE_SEQ = PARENT_CODE_SEQ
ORDER SIBLINGS BY SORT_SEQ

'DB > Oracle' 카테고리의 다른 글

[Oracle] hint  (0) 2016.07.13
[Oracle] NOLOGGING  (0) 2016.07.13
[Oracle] Trigger, enable, disable  (0) 2016.05.13
[Oracle] RECYCLEBIN, 휴지통 비우기  (0) 2016.02.04
[Oracle] function-based index 조회  (0) 2016.02.04
Comments