select
empno, lpad(' ',2*level) || ename as Ename
from emp
start with mgr is null
connect by prior
empno = mgr
/
works fine on 8.1.7
Cheers.
|
Results 1 to 5 of 5
Threaded View
|
Click Here to Expand Forum to Full Width |