Oracle根据表名获得其主键的字段名

SQL如下：

    

select a.table_name, b.column_name  from user_constraints a, user_cons_columns b where a.constraint_name = b.constraint_name   and a.constraint_type = 'P'   and a.table_name in ('TABLENAME')