Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Command?
In article <3726642A.39923C7C_at_flash.net>,
Al Ruiz <arruiz_at_flash.net> writes:
> If you use PL/SQL you can create a loop (e.g.)
>
> Loop
> ..
> ..
> insert into .....
> commit
> ..
> ..
> ..
> end loop
Yes, you can do this. But if you can do it all in one insert statement, you will generally see a big performance improvement. The only time you will want to do this in a loop, is if your rollback segment isn't large enough to hold all the records at once. But even then, enlarging the rollback segment and doing it in one insert statement might give a performance improvement.
Remco
--
rd1936: 10:45pm up 1 day, 6:40, 6 users, load average: 1.53, 1.47, 1.42
Received on Mon May 03 1999 - 15:50:28 CDT
![]() |
![]() |