데이터베이스/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
반응형