查询所有主键列表
SELECT
cu.*
FROM
user_cons_columns cu,
user_constraints au
WHERE
cu.constraint_name = au.constraint_name
AND au.constraint_type = 'P'
AND au.table_name IN ( SELECT user_tables FROM user_tab_columns )
查询所有没主键的表
SELECT * FROM user_tables WHERE table_name not in (
SELECT TABLE_NAME FROM user_constraints WHERE constraint_type = 'P'
)