반응형
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
반응형
'데이터베이스 > Oracle' 카테고리의 다른 글
| Orange for Oracle 단축키 (0) | 2019.01.28 |
|---|---|
| [oracle]GREATEST, LEAST 함수 (0) | 2018.06.22 |
| Oracle 달력 쿼리 (0) | 2016.10.13 |
| [오라클]그룹별 순번 만들기 (0) | 2013.06.21 |
| [오라클]유저생성 (0) | 2013.04.09 |