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
Answers were Sorted based on User's Feedback
Answer / hussain
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|
What is RAC in oracle?
How do you create a db file?
How do you declare a variable in pl sql?
What are the datatypes available in pl/sql ?
How do I view tables in mysql?
Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?
Can a varchar be a primary key?
What are the pre requisites?
What is not equal in sql?
what are ddl statements in mysql? : Sql dba
Types of backups ?
How is data stored on a disk?