查找对应表的主键字段列
select
column_name
FROM
dba_ind_columns
where
index_name in
(
select
INDEX_NAME
from
ALL_CONSTRAINTS
where
constraint_type='P'
AND TABLE_NAME ='MEETING_COPY'
)

SELECT a.OWNER as "模式名",a.TABLE_NAME as "表名",b.COLUMN_NAME as "列名", a.CONSTRAINT_NAME as "约束名" from DBA_CONSTRAINTS a, ALL_CONS_COLUMNS b where a.CONSTRAINT_NAME=b.CONSTRAINT_NAME and CONSTRAINT_TYPE='P';