Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> connect question

connect question

From: Jack Simmions <laclac01_at_yahoo.com>
Date: Wed, 17 Oct 2001 15:46:24 -0400
Message-ID: <3bcddcfc$1_2@corp-news.newsgroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US