Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: for d in c loop; insert; commit ...
Ooops. Forgot to mention this is an old database (probably started
with version 6) with some major work done when they moved to 8i on
Solaris. Currently running 9.2.0.8 on Linux x86_64. Perhaps this made
sense in an older version?
On 8/15/07, stv <stvsmth_at_gmail.com> wrote:
> Why in the world did I inherit a database with all this nonsense everywhere ...
>
> lc := 0;
> For d in C loop
> lc := lc + 1;
> # insert stuff
> if mod(lc, 50) = 0 then commit; end if;
> end loop;
> commit;
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 15 2007 - 18:01:11 CDT
![]() |
![]() |