Tuesday, March 3, 2020

Oracle tree hierarchical query

In a hierarchical querytraverse the tree from the branch level to the top

select *
from EMP
start with EMPNO = :x
connect by prior MGR = EMPNO;

No comments:

Post a Comment