begin
for t in (select table_name from user_tables where table_name like 'ABC%' ) loop
execute immediate 'drop table '||t.table_name;
end loop;
end;
/
select 'drop table '||table_name||' purge;' from user_tables where table_name like 'ABC%';
然后执行一边结果集就OK了