Records in hirarchial

[kiss07]

Hi,

In employee table i want to display records in hirarchial
order.How can i do it..I want query.Hirarchial means follwing:

Personal Manager
----Manager
-----Team Leader
------Team Member
--------Tester..

Its Ok.Anybody ..Pls

Regards,
Arun..

[frozenmist]

Hi,

In employee table i want to display records in hirarchial
order.How can i do it..I want query.Hirarchial means follwing:

Personal Manager
----Manager
-----Team Leader
------Team Member
--------Tester..

Its Ok.Anybody ..Pls

Regards,
Arun..

You can do it if there is a column to identify the level

[debasisdas]

COLUMN EMPLOYEE FORMAT A20
 
SELECT LEVEL,LPAD(' ',2*(LEVEL-1))||ENAME "EMPLOYEE" ,EMPNO,MGR FROM EMP
START WITH MGR IS NULL CONNECT BY PRIOR EMPNO=MGR
 
 

Please try the above code in SCOTT schema on EMP table...

[kiss07]

Dear deba,

Thanku very much.

Arun

[debasisdas]

Dear Arun

U are always welcome

But why u want code everytime in all your posts.

try somthing by yourself.

If u can't solve it then only post in forum.

Debasis