select lpad(' ',4*(level-1))||ename name ,empno,mgr from emp
start with mgr is null
connect by prior empno=mgr;
name empno mgr
-------------------- --------- ---------
king 7839
jones 7566 7839
scott 7788 7566
adams 7876 7788
ford 7902 7566
smith 7369 7902
blake 7698 7839
allen 7499 7698
ward 7521 7698
martin 7654 7698
turner 7844 7698
james 7900 7698
clark 7782 7839
miller 7934 7782
14 rows selected.
sql>