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!

Hierarchical query with multiple parents and children no parents

794727Feb 10 2014 — edited Feb 10 2014

Hi for All,

I have a follow issue:

1 , parent_1     ,

2 , child_1      , 1 

3 , child_2      , 1

4 , grandchild_1 , 2

5 , parent_2     ,

6 , child_3      , 5

7 , child_0      ,

In this case, I can have multiple parents and I also have children who don't have parents. Can anyone help me solve this problem

Regards
This post has been answered by Frank Kulash on Feb 10 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 10 2014
Added on Feb 10 2014
18 comments
3,314 views