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列的值。