빅데이터과정/SQL

#43_140812_계층적질의문

하히후후후 2014. 8. 12. 13:49
728x90


# 계층적질의문



 

  • 계층적질의문(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;

 


 

 














저작자표시 비영리 변경금지 (새창열림)