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

+ Recent posts