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
- 6609 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
How do I view a sql trace file?
How do I find sql profiler?
What are pl/sql cursors?
what is schema? : Sql dba
What are the sql versions?
How does sql profiler work?
Describe types of sql statements?
How does sql*loader handles newline characters in a record? : aql loader
what are all the common sql function? : Sql dba
What are the ddl commands?
What is the location of pre_defined_functions.
Which one is better subquery or joins?
How do I create a memory optimized filegroup?
Can we use ddl commands in pl sql?
how is myisam table stored? : Sql dba
