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
What is the use of index in sql?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
How is data stored in sql?
Can we use insert statement in function?
What is set transaction?
What is sql and also describe types of sql statements?
What is trigger and stored procedure in sql?
What is the difference between sql, mysql and sql server?
Is pl sql useful?
how to select first 5 records from a table? : Sql dba
Explain correlated query work?
Can we use join in subquery?
What is application trigger?
What are sql constraints?
Explain the savepoint statement.