List of foreign key constraints
by Taavi Rammar

To get all foreign key constraints for Oracle, run following query:
select table_name,constraint_name,column_name from user_cons_columns where constraint_name like '%FK%';
This might not give you correct results thou cause it assumes that your foreign keys are named propertly (name needs to include 'FK').

Copyright by techTips