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 / 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 |
Post New Answer View All Answers
what are different types of collation sensitivity? : Sql dba
What is the difference between delete and truncate statement in sql?
What is sql analyzer?
Can we insert data into materialized view?
What are the usages of sql?
What do you understand by pl/sql cursors?
What is a left inner join?
What is sql indexing?
Explain isolation levels. : Transact sql
What are analytical functions in sql?
How many triggers can be applied on a table?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is the use of function "module procedure" in pl/sql?
what is innodb? : Sql dba
What is group by in sql?