데이터베이스/Oracle

행을 열로 표시하기

만랩사원 2011. 10. 14. 13:01
반응형

http://blog.naver.com/nanandayo?Redirect=Log&logNo=60094984184

http://blog.naver.com/xxeno?Redirect=Log&logNo=150073442665

계층형 쿼리 ( START WITH ..... CONNECT BY PRIOR ) ORACLE
http://www.cyworld.com/ajkwin79/2741234

SELECT LEVEL, EMPNO, MGR

  FROM  EMP

START  WITH MGR IS NULL

CONNECT BY PRIOR EMPNO = MGR;

http://cyhome.cyworld.com/?home_id=a1672930&postSeq=1882815

반응형