How to write a procedure for displying the data in a TREE or (PARENT and CHILD

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 / surendrababu

2 Answers
7281 Views
Zensar, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , fo..

Answer / 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

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , fo..

Answer / rv

You can use Select..ConnectBY.. PRIOR clause in Oracle to
generate the data in tree structure. Google for the apt
syntax and usage.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer

More SQL PLSQL Interview Questions

I have done oracle 10g. I need a project knowledge. So if u please send a project how it should be done,Or you can send email link. I will be very grateful to u.

1 Answers

what is a relationship and what are they? : Sql dba

0 Answers

What is the use of function in sql?

0 Answers

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers Satyam,

What is a pdo connection?

0 Answers

How to combine two stored procedures in sql?

0 Answers

How to recompile a already made trigger?

2 Answers

what is union, minus and interact commands? : Sql dba

0 Answers

<<labele>> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?

1 Answers ITC Infotech,

Explain how to use transactions efficiently : transact sql