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
- 2 Answers
- 6140 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Why is pl sql needed?
What are different types of sql commands?
How do you add a column to a table?
What is schema in sql?
what's the difference between a primary key and a unique key? : Sql dba
Explain autonomous transaction.
What is compute?
Define commit?
what is 'mysqlcheck'? : Sql dba
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is the use of <> sql?
How do I kill a query in postgresql?
What is full join in sql?
Which data type is a composite type?
What is informix sql?
