hierarchical tree

[jeevalokesh]

hi


plz explain how to create hierarchical tree ?

[frozenmist]

Hi Jeeva,
Thanks for posting the question.
But do refrain from posting the same question more than once in the future.

Cheers

[debasisdas]

Previously u had put the same question in FORMS.

If u want the same in SQL i can sove it for you .

It will be better if u handle the forms part.

please do post back.

[debasisdas]

If u want hierarchical tree structure in SQL use the following code.

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