17,377
社区成员
发帖
与我相关
我的任务
分享
create or replace procedure pro_droptable is
cursor cur is select table_name from user_tables;
drop_sql varchar2(1000);
begin
for tbname in cur loop
begin
drop_sql:='drop table '||tbname.table_name||' ;';
execute immediate drop_sql;
end;
end loop;
end pro_droptable;