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
Answer Posted / 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 |
Post New Answer View All Answers
Is foreign key mandatory?
Is join and inner join the same?
In what condition is it good to disable a trigger?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
Which is better cte or subquery?
How does a self join work?
Inline the values in PL/SQL, what does it mean.?
Explain constraints in sql?
How does a covering index work?
What is a database trigger?
Which join is like an inner join?
Why do we use partitions in sql?
What is normalisation in sql?
What is pl/sql table? Why it is used?
How many types of normalization are there?