方法一:
declare
begin
for vcur in (select t.TABLE_NAME
from user_tables t
where t.TABLE_NAME like 'HIS_%') loop
execute immediate 'drop table '||vcur.table_name;
end loop;
end;
方法二:
SELECT 'drop table '||TABLE_NAME ||';' FROM USER_TABLES WHERE TABLE_NAME LIKE 'HIS_%';
执行后复制结果,重复执行直到删除干净