select a.owner,a.constraint_name,a.table_name,a.column_name
from user_cons_columns a,user_constraints b
where a.constraint_name=b.constraint_name
from user_cons_columns a,user_constraints b
where a.constraint_name=b.constraint_name
from user_cons_columns a,user_constraints b
where a.constraint_name=b.constraint_name
AND B.CONSTRAINT_TYPE='P';
user_constraints换成
dba_cons_columns
dba_constraints