This discussion is archived
1 Reply Latest reply: Jan 29, 2013 2:14 AM by HamidHelal RSS

connect by - help

:) Newbie
Currently Being Moderated
i have emp table

select ename,job,mgr,level
from emp start with mgr is null connect by prior empno = mgr;

KING     PRESIDENT          1
JONES     MANAGER     *7839*     2
SCOTT     ANALYST     *7566*     3
ADAMS     CLERK     7788     4
FORD     ANALYST     7566     3
SMITH     CLERK     7902     4
BLAKE     MANAGER     7839     2
ALLEN     SALESMAN     7698     3
WARD     SALESMAN     7698     3
MARTIN     SALESMAN     7698     3
TURNER     SALESMAN     7698     3
JAMES     CLERK     7698     3
CLARK     MANAGER     7839     2
MILLER     CLERK     7782     3

above query will give manager wise employees, but how can i get the manager name instead of manager code (highlighted in bold) in the query

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points