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
Answers were Sorted based on User's Feedback
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 |
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 |
What does 0 mean in sql?
what are the advantages of sql ? : Sql dba
How to Declare Fixed Length String Value In PL SQL
How do I count records in sql?
What are the advantages of sql?
suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??
Why do we use sql constraints?
What is procedure in pl sql?
What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.
what is acid property in database? : Sql dba
Why is theta join required?
what is offset-fetch filter in tsql? : Transact sql