declare
cursor c_t is (select table_name from user_tables where table_name like 'D%');--声明一个游标
table_name user_tables.table_name%type;--声明一个表名的变量
begin
open c_t;
loop
fetch c_t into table_name;
exit when c_t%notfound;
execute immediate 'truncate table ' || table_name;--动态sql删除
end loop;
close c_t;
end;
原文地址:https://blog.csdn.net/luman1991/article/details/54343910