- PRIOR가 붙은 쪽이 parent row 임을 뜻함
* Top-Down: PK에 PRIOR
select *
from emp
start with empno = 7839
connect by prior empno = mgr;
* Bottom-Up: FK에 PRIOR
select *
from emp
start with empno = 7521
connect by empno = prior mgr;
'Oracle > SQL Fundamentals II' 카테고리의 다른 글
15일차 # 7-11: 결과를 보기 좋게 만들기 (0) | 2012.04.24 |
---|---|
15일차 # 7-10: Level, a Hierarchical Query Pseudocolumn (0) | 2012.04.24 |
15일차 # 7-3 ~ 5: Hierarchical Query (계층 질의) (0) | 2012.04.24 |
14일차 # 6-22: WITH 절 (0) | 2012.04.23 |
14일차 # 6-20: Delete Case (Correlated DELETE) (0) | 2012.04.23 |