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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing
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,464 views