1 Reply Latest reply: Jan 29, 2013 4:14 AM by HamidHelal RSS

    connect by - help

    a_cute_person
      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