Finding Foreign Key Constraints in Oracle by JP Vijaykumar

http://www.databasejournal.com/features/oracle/article.php/3665591/Findi...

SELECT owner, constraint_name, constraint_type, table_name, r_owner,
r_constraint_name
FROM all_constraints
WHERE constraint_type = 'R'
AND r_constraint_name IN (
SELECT constraint_name
FROM all_constraints
WHERE constraint_type IN ('P', 'U')
AND table_name = 'TEMP_JP1');

Replay TEMP_JP1 with your own table.