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
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
Is record in pl sql?
What problem one might face while writing log information to a data-base table in pl/sql?
Explain isolation levels. : Transact sql
How do you write a subquery?
Can we insert delete data in view?
What are the different dml commands in sql?
What does select * from mean in sql?
Can two tables have same primary key?
What is difference between procedure and trigger?
Define join and name different types of joins?
What is the difference between rename and alias?
what is query cache in mysql? : Sql dba
What is auto increment in sql?
What is bulk compiling in pl/sql.?
Which command is used to delete a trigger?