Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Root and leaf node from a hierarchical tree.
I did that and the result I get is like..
Parent_Id Node_Id
| rootA
| rootA A-child1
| A-child1 A-leaf
| rootB
| rootB B-child1
| rootB B-child12
| B-child1 B1-leaf
| B-child12 B12-leaf
when I am on leaf node - I know who is the immediate parent but I do not have the info who is the root. Received on Thu Sep 22 2005 - 09:32:33 CDT