SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

display MGR name

V prasadDec 7 2010 — edited Dec 7 2010

EMPNO ENAME MGR
---------------------- --------------- ----------------------
7369 SMITH 7902
7499 ALLEN 7698
7521 WARD 7698
7566 JONES 7839
7654 MARTIN 7698
7698 BLAKE 7839
7782 CLARK 7839
7788 SCOTT 7566
7839 KING
7876 ADAMS 7788
7900 JAMES 7698
7902 FORD 7566
7934 MILLER 7782

i want to display the data like

empno.... ename... mgr.... mgrNAME.

means for that employee, i want to display his manager name..???

This post has been answered by Adigozalov Gurban on Dec 7 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 4 2011

Added on Dec 7 2010

4 comments

1,265 views