Oracle PL/SQL存储过程

create or replace procedure delete_table
as
i integer;
str varchar2(50);
begin
  i := 0;
  while i<11100 loop
    begin
        str:= 'delete   table   table_'||i; 
        i := i+1;
        execute   immediate   str;
    end;
  end loop;
end;
commit;
哪儿有错，请帮忙改下，谢谢

答案：create or replace procedure delete_table
as
i integer;
str varchar2(50);
begin
  i := 0;
  while i<11100 loop
   
        str:= 'delete   table   table_'||i; 
        i := i+1;
        execute   immediate   str;
      commit;
  end loop;
end delete_table;

其他：没错吧 create or replace procedure delete_table
as
i integer;
str varchar2(50);
begin
  i := 0;
  while i<11100 loop
    begin
        str:= 'delete   table   table_'||i;
        i := i+1;
        execute   immediate   str;
    end;
  end loop;
  commit;                                   --------------------------------
end delete_table;----------------------------

end 后面加存储过程名字。commit 提上面一行 

上一个：关于Oracle的数据类型
下一个：oracle安装还没学先问的问题