主キーを調べる

SELECT ucc.table_name,ucc.constraint_name,ucc.column_name
 FROM user_cons_columns ucc,user_constraints uc 
WHERE ucc.constraint_name=uc.constraint_name AND uc.constraint_type='P';