Hi,
you can user the connect by prior clause

try this query on the emp table:
select
lpad(' ',2*(level-1))|| ename ,
e.empno, e.mgr, e.job, e.deptno
from emp e
connect by prior empno = mgr
start with mgr is null

cheers,
R.