pk.sql

select ut.table_name ,uc.constraint_name, uc.constraint_type 
 from user_constraints uc,
      user_tables ut
 where uc.table_name = ut.table_name(+)
   and uc.constraint_type='P';