Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> connect question
I am trying to write a query to perform the following:
display the names of the employees and their manager. I need to print it out
in one column.
format looks like this
_______ reports to ________
this is what I have now:
select lpad(empno, level*5,' ')||' '||ename||' '||job tree
from emp
connect by mgr = prior empno
start with mgr is null; Received on Wed Oct 17 2001 - 14:46:24 CDT