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;