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
- 7160 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
How to use transactions efficiently : transact sql
How does stored procedure reduce network traffic?
What is serial sql?
How to avoid duplicate records in a query?
what is timestamp in mysql? : Sql dba
what tools available for managing mysql server? : Sql dba
What is the use of & in pl sql?
What is primary key and foreign key with example?
How many databases can sql express handle?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What is int identity in sql?
what is the difference between join and union? : Sql dba
Does execute immediate commit?
what's the difference between a primary key and a unique key? : Sql dba
Why do we need pl sql?
