生成oracle 批量删除表数据 select ‘DROP TABLE ‘||TABLE_NAME||’ cascade constraints;’ from user_tables t ; 也可以生成指定表 drop语句 select ‘DROP TABLE ‘||TABLE_NAME||’ cascade constraints;’ from user_tables t where t.TABLE_NAME like ‘XXXXX_C_%’; 执行生成的drop语句,就可删掉表了