select a.TABLE_NAME, b.table_name, a.CONSTRAINT_NAME
from user_constraints a, user_constraints b
where (a.CONSTRAINT_NAME = b.r_constraint_name
and a.CONSTRAINT_TYPE = 'P'
AND b.constraint_type = 'R') order by a.table_name
from user_constraints a, user_constraints b
where (a.CONSTRAINT_NAME = b.r_constraint_name
and a.CONSTRAINT_TYPE = 'P'
AND b.constraint_type = 'R') order by a.table_name