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.