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
7400 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 is graph sql?

1040

How do I install microsoft sql?

1116

What is row_number () in sql?

1025

What are the query optimization techniques?

1000

Which join is default?

1017

How do you exit in sql?

1159

What plvcmt and plvrb does in pl/sql?

1366

Does truncate table reset auto increment?

1051

Why trigger is used in sql?

1017

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1250

Enlist some predefined exceptions?

1115

what are the performance and scalability characteristics of mysql? : Sql dba

1035

Write a unique difference between a function and a stored procedure.

1054

How many clustered indexes can you have?

1038

what are the drivers in mysql? : Sql dba

1061