Recent site activity

Examples‎ > ‎

Commit Frequency (Oracle)


create table toto (dummy number);


insert into toto values ('1');
commit;

vs

insert into toto values ('1');
insert into toto values ('1');
... 95 more inserts ...
insert into toto values ('1');
insert into toto values ('1');
insert into toto values ('1');
commit

vs

begin
  for i in 1..100 loop
     insert into toto values ('1');
     commit;
  end loop;
end; 
/


Comments