var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Finding Immediate parent of a leaf Node
I have to write a PL/SQL code where it will take all the leaf nodes of the tree and find immediate parent of that leaf node. How can i write in PL/SQL using connect by prior function.
I have two columns Child, Parent in my table.
Why would you want to use PL/SQL? Why not just use SQL?
Here is a link to some essential reading before you start to try to implement solutions based on hierarchical retrieval.
Tags for this Thread