Oracle中根据表查询对应的主键

select a.constraint_name, a.column_name, a.table_name
  from user_cons_columns a, user_constraints b
 where a.constraint_name = b.constraint_name
   and a.table_name = '表名大写'
   and b.constraint_type = 'P'