Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Parent Child Query

424110Nov 4 2010 — edited Nov 4 2010
i got the output for parent child relation

select
lpad(' ', 2*level) || child
from
prune_test
start with
parent is null
connect by
prior child=parent

like
1
----12
---- 120
-----124
-----127
-----712
-------7122
-------7125
--------7127

But I want out like
Parent Child1 Child 2 child3
1
1 12
1 12 120
1 12 124
1 12 127
1 12 712
1 12 712 7122
1 12 712 7125
1 12 712 7127

Can any one help me...
Thanks
mani

Edited by: Mani on Nov 4, 2010 6:54 PM
This post has been answered by pollywog on Nov 4 2010
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 2 2010
Added on Nov 4 2010
#query
3 comments
1,481 views