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
- 7120 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 is the process of copying data from table a to table b?
What do you understand by pl/sql packages?
What is crud stand for?
What are the types of queries in sql?
What are the types of triggers in sql?
Why sql query is slow?
What is cartesian join in sql?
What is difference between inner join and cross join?
what is blob? : Sql dba
What is before trigger?
How is use pl and sql?
What are the ways on commenting in a pl/sql code?
Is sql workbench free?
Is inner join same as self join?
Is there any restriction on the use of union in embedded sql?
