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
- 6388 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
Can we rename a column in the output of sql query?
How do I find duplicates in a single column in sql?
Explain the commit statement.
Which table is left in left join?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
Which constraints we can use while creating database in sql?
What is a table?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What are data types in pl sql?
what is an extent ? : Sql dba
What are pl sql data types?
How to run sql statements through the web interface?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
Are left and right joins the same?
What is the maximum number of triggers, you can apply on a single table?
