Oracle/SQL Fundamentals II

15일차 # 7-7: Top-Down vs. Bottom-Up

Bohemian life 2012. 4. 24. 20:27

 - 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;