Skip to Main Content

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!

retrieving root id in hierarchial data structure.

udnappMay 21 2013 — edited May 21 2013
HI,

I have data arranged in tree having parent child relationship as below .But i need to retrieve the root in the tree.Please let me know how can i achieve this.


parent child

A B
B C
C D
D E
M N
N O



In the above case i need to get root element of tree through query i.e in my case it will be A and N.How can we achieve this
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 18 2013
Added on May 21 2013
10 comments
368 views