select a.table_name,a.constraint_name,b.table_name,b.constraint_name
from dba_constraints a,dba_constraints b
where a.r_constraint_name=b.constraint_name
and b.table_name='XXX'
from dba_constraints a,dba_constraints b
where a.r_constraint_name=b.constraint_name
and b.table_name='XXX'