all_constraints that identify primary keys to records of all_constraints that identify foreign keys, it is possible to select primary-foreign key relations. select
pk.owner pk_owner,
pk.table_name pk_table,
fk.owner fk_owner,
fk.table_name fk_table,
pk.status pk_status,
fk.status fk_status
from
all_constraints pk join
all_constraints fk on pk.owner = fk.r_owner and
pk.constraint_name = fk.r_constraint_name
where
pk.owner = user and
pk.table_name = 'XYZ'
-- fk.constraint_name = 'ABC_FK'
;