You can use Select..ConnectBY.. PRIOR clause in Oracle to generate the da

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

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

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

How many types of privileges are available in sql?

1404

What is recursive join in sql?

1070

What are the different sql languages?

1093

what is the bond code in materialized view?

3062

What is lexical units in pl sql?

1209

how is exception handling handled in mysql? : Sql dba

1132

What is the difference between cluster and non-cluster index?

1160

explain the difference between bool, tinyint and bit. : Sql dba

1063

What is oracle and pl sql?

1159

What is $$ in sql?

1046

Which constraints we can use while creating database in sql?

1121

What does truncate mean in sql?

1086

What is latest version of sql?

1102

What found sql?

995

What are the properties of a transaction?

1186