How to write a procedure for displying the data in a TREE or (PARENT and CHILD

How to write a procedure for displying the data in a TREE
or (PARENT and CHILD ) relationship , for ex: A is the main
project id, for this project B,C,D are sub tasks(sub
project id's) for B the sub tasks are e,f,g and for c is
h ,i ,j and for d is k,l,m
now i need to display the o/p in a TREE fashion

pls help me ,
thanks in advance
surendra

Question Posted / surendrababu

2 Answers
6603 Views
Zensar, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , fo..

Answer / hussain

hi,
i think this may help u,

select lpad('',level*4)||projectid,subtask from xyz
start with projectid ='&a' connect by prior projectid=subproid

Is This Answer Correct ?

2 Yes

0 No

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , fo..

Answer / rv

You can use Select..ConnectBY.. PRIOR clause in Oracle to
generate the data in tree structure. Google for the apt
syntax and usage.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer