查询没有主键的表

select t.table_name from user_tables t,user_cons_columns c where c.table_name=t.table_name and c.column_name='ID' and not exists(select 1
  from dba_constraints a, dba_cons_columns b
 where a.CONSTRAINT_TYPE = 'P'
   and a.constraint_name = b.constraint_name and a.table_name=t.table_name);