Primary key and foreign constraint in oracle

[ashwani123]

Hi,

Is there any system table that stores theprimary key column name,table name, foreign key column name and table name in the oracle database?

[r035198x]

Use all_constraints

SELECT a.owner, a.table_name, b.column_name
  FROM all_constraints a, all_cons_columns b
 WHERE a.constraint_type='P'
   AND a.constraint_name=b.constraint_name
   AND a.table_name = 'yourTableName'