In Oracle, view the constraints between the primary key and the foreign key corresponding to a table. view the statement:

Record in table: user_constraints

 

  Select A. Owner, -- Primary Key owner
A. table_name, -- Primary Key table
B. column_name, -- Primary Key Column
C. Owner, -- Foreign key owner
C. table_name, -- Foreign key table
D. column_name -- Foreign key column
  From User_constraints
  Left   Join User_cons_columns B
On A. constraint_name = B. constraint_name
  Left   Join User_constraints C
On C. r_constraint_name = A. constraint_name
  Left   Join User_cons_columns d
On C. constraint_name = D. constraint_name
  Where A. constraint_type = ' P '
And A. table_name = ' Xxx '   -- Table for which you need to view the relationship between the primary and Foreign keys
  Order   By A. table_name