11/23/12

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:

Post a Comment

Please refrain for marketing messages and unnecessary back links.

Workflow errors on New Hire and Add employment instance

User tries to hire a new person or tries to add a new organization relationship encounters a series of error messages related to workflow...

Trending in this Blog this month