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
- 6389 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 enter binary numbers in sql statements? : Sql dba
List out the acid properties and explain?
Do we need to create index on primary key?
How do you write an index?
What is difference between sql and excel?
What is a database event trigger?
What is sql*loader and what is it used for? : aql loader
what happens if you no create privilege in a database? : Sql dba
What are joins in sql?
How do I view a sql database?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
Explain what is a column in a table?
Does pl sql work in mysql?
How to create an array in pl/sql?
What is difference between pl and sql?
