hi, i think this may help u, select lpad('',level*4)||pr

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

Question Posted / hussain

2 Answers
7221 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

Please Help Members By Posting Answers For Below Questions

What are the set operators in sql?

1056

What is an exception in pl/sql?

1055

Can we join tables without foreign key?

947

What if we write return in procedure?

1400

What is sql engine in oracle?

972

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1130

What is prepared statement in sql?

1036

Does oracle roll back the transaction on an error?

1000

Why do we use set serveroutput on?

955

Why is partition used in sql?

1104

What are some emotional triggers?

964

What is a pragma statement?

1250

How do you select unique values in sql?

980

What is materialized view in sql?

909

What is the usage of sql functions?

1128