create table test(id int);declarebegin for i in 1..10000 loop insert into test values(i); if mod(i,5)=0 then commit; end if; end loopend;
