select a.constraint_type,a.constraint_name,b.column_name from all_constraints a,all_cons_columns b where a.owner=b.owner and a.constraint_name=b.constraint_name and a.CONSTRAINT_TYPE ='P' and a.owner='USER' and a.table_name='TABLNAME';P 主键 USER 表所属的用户 TABLNAME 表名
from all_constraints a,all_cons_columns b
where
a.owner=b.owner and
a.constraint_name=b.constraint_name and
a.CONSTRAINT_TYPE ='P' and
a.owner='USER' and
a.table_name='TABLNAME';P 主键
USER 表所属的用户
TABLNAME 表名