#43_140812_계층적질의문

# 계층적질의문

 

• 계층적질의문(SYS_CONNECT_BY_PATH)

  

# 순방향 SELECT ename, SYS_CONNECT_BY_PATH(ENAME||'('||sal||')','/') employee FROM EMP START 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||')','/') employee FROM EMP START WITH ename='ADAMS' CONNECT BY EMPNO = PRIOR MGR;