Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2013

    Thumbs up 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.


  2. #2
    Join Date
    Dec 2007
    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.
    Oracle Documentation

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts