Re: Information retrieval in parent-child hierachy

For a max. of 3 levels this query will work: select empno parent, empno child from emp --base level union all
select mgr, empno from emp --upper level union all
select b.mgr, a.empno from emp a, emp b --second upper level where a.mgr=b.empno
/

For known number of levels, more upper levels can be union with this query. Received on Mon Jun 10 2002 - 05:07:11 CEST