level,empno,ename,sal,mgr
from emp
connect by prior XX
提问者：用户11739752015-07-19 16:45
个回答
GonyMaster
2015-12-15 23:55:48
通过子节点向根节点追朔.
select * from persons.dept start with deptid=76 connect by prior paredeptid=deptid
通过根节点遍历子节点.
select * from persons.dept start with deptid=0 connect by prior deptid=paredeptid