Header Ads

  • Breaking News

    SQL query to get all the child records for a parent record

    SQL query to get all the child records for a parent record:
    select recname from psrecdefn
    CONNECT BY PRIOR RECNAME=PARENTRECNAME
    START WITH PARENTRECNAME = :1 -- Parent Record name



    This SQL will help in analyzing whenever we have to delete data in a record and to retrieve all the child definitions of a record. However, this will work only for records which have a parent record specified in record properties.

    No comments

    Please refrain for marketing messages and unnecessary back links.

    Post Top Ad

    Post Bottom Ad