Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2010
    Posts
    1

    Wink Unanswered: Complex recursive join

    How to create a recursive join where parent and child are store in same field. Consider below example:

    SF-AIRPORT (Parent)
    SF-AIRPORT/192 AIRFIELD ENGINEER (child)

    Query needs to find out all the child elements for the parent (In above example all child are concatenated by / in the above example for parent SF-AIRPORT)

    I was trying to use SUBSTR AND INSTR functions with little success

    Any help or pointers

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    You need to fix your database design, then you can use CONNECT BY

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
  •