Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2009

    Unanswered: problem to structure recursive query

    Hi all,
    i would know if someone have any idea if it's possible to structure recursive query like that; the 2 tables i use are:

    Table Folder (Folder_name, Dbid)
    Table Obj_Fld (Folder_dbid, object_dbid)

    - Table Folder contains Folder_name and Dbid
    - Table Obj_Fld contains all objects (object_dbid) contained in Folder (Folder_dbid); this objects can be folder too.

    in practise, i have to structurate a query to extract, for only object_dbid , the Folder (Folder_name) where he is, go recursively if the Folder is child of another folder.
    Someone have any idea?
    thanks a lot!

  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL

    Cool Hierarchical query

    Check out Hierarchical queries in the fine Oracle® Database SQL Reference.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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