Oracle查看主键在哪一列

select owner,constraint_name,table_name,column_name 
from user_cons_columns 
where table_name='大写表名' and constraint_name in 
                             (select constraint_name 
                             from user_constraints 
                             where table_name='大写表名' and constraint_type='P');

如果主键是(a列,b列)类型的只能查询出b列的值。