계층적질의문 썸네일형 리스트형 #43_140812_계층적질의문 # 계층적질의문 계층적질의문(SYS_CONNECT_BY_PATH) # 순방향SELECT ename, SYS_CONNECT_BY_PATH(ENAME||'('||sal||')','/') employeeFROM EMPSTART WITH ename='KING'CONNECT BY PRIOR EMPNO = MGR SELECT ename, LEVEL, LPAD(' ', 2*LEVEL)||SYS_CONNECT_BY_PATH(ENAME,'/') PATH FROM EMP START WITH ename='KING'CONNECT BY PRIOR EMPNO = MGR; # 역방향SELECT ename, LEVEL, SYS_CONNECT_BY_PATH(ENAME||'('||sal||')','/') employeeFROM EMPS.. 더보기 이전 1 다음