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
Answers were Sorted based on User's Feedback
Answer / hussain
hi,
i think this may help u,
select lpad('',level*4)||projectid,subtask from xyz
start with projectid ='&a' connect by prior projectid=subproid
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What are the disadvantages of not performing database normalization?
how can we destroy the cookie? : Sql dba
Which is better stored procedure or query?
What is ROWID?
Which data type doesn't allow null data type?
what are the t string functions available in tsql? : Transact sql
what is inline command?
what is a record in a database ? : Sql dba
How do you optimize a query?
What is partition in sql query?
Can we perform dml in function?