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 is rename in sql?
Does sql support programming?
Can we use views in stored procedure?
how many tables will create when we create table, what are they? : Sql dba
What is a boolean in sql?
Is sql better than access?
What is anonymous block in sql?
How to Declare Fixed Length String Value In PL SQL
how can we repair a mysql table? : Sql dba
what are the limitations of identity column? : Transact sql
Which tcp/ip port does sql server run?
Can we join same table in sql?
How to start oracle sql developer?
what is the stuff function and how does it differ from the replace function? : Sql dba
What is crud stand for?