oracle存储过程for语句用法，并且每500条提交一次。 create or replace procedure ps_test is begin for i in 1..10000 loop --delete from test where name=to_char(i); - insert into test values(to_char(i),i+2); if mod(i,500) = 0 then commit; end if;
oracle存储过程for语句用法，并且每500条提交一次。
create or replace procedure ps_test is
begin
       for i in 1..10000
       loop
         --delete from test where name=to_char(i);
-
insert into test values(to_char(i),i+2);
       if mod(i,500) = 0 then
       commit;
       end if;
       end loop;
       commit;
end ps_test;