Oracle Help

• How to Find a Child Tables List from the Parent Table?

SELECT table_name, constraint_name FROM user_constraints

WHERE r_constraint_name in

(SELECT constraint_name FROM user_constraints WHERE table_name = 'PARENT_TABLE' )

ORDER BY Table_name ;