Oracle FK

select owner,constraint_name,constraint_type,table_name,r_owner,r_constraint_name from all_constraints where constraint_type in (‘P’,‘U’) and table_name=‘table_name’;

sumber : 1. http://www.databasejournal.com/features/oracle/article.php/3665591/Finding-Foreign-Key-Constraints-in-Oracle.htm