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
- 7263 Views
- Zensar, I also Faced
- E-Mail Answers
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
Why is a trigger used?
what does the t-sql command ident_current does? : Transact sql
How does sql store data?
What is self-join and what is the requirement of self-join?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
How many indexes can be created on a table in sql?
What is difference between pl and sql?
How to run sql statements with oracle sql developer?
What are different types of keys?
What does the sign mean in sql?
what is difference between delete and truncate commands? : Sql dba
Is postgresql a nosql database?
How to write html code in pl sql?
What are inner outer left and right joins in sql?
What is a natural join sql?
