SELECT *
FROM user_constraints
WHERE r_constraint_name IN (SELECT constraint_name
FROM user_constraints
WHERE table_name = upper('table name'));
FROM user_constraints
WHERE r_constraint_name IN (SELECT constraint_name
FROM user_constraints
WHERE table_name = upper('table name'));
