Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7260 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
What are conditional predicates?
What is materialized view in sql?
How can we implement rollback or commit statement in a trigger?
Why do we use partitions in sql?
Why is sharding used?
How is debugging done?
What are the qualities of 2nf?
Does oracle roll back the transaction on an error?
What are the different types of sql commands?
What is the size of partition table?
What is pl/sql language case sensitive?
What port does sql server use?
Why is normalization important?
How do you select unique values in sql?
What is mutating sql table?
