Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Command?

Re: SQL Command?

From: Remco Blaakmeer <remco_at_rd1936.quicknet.nl>
Date: 3 May 1999 20:50:28 GMT
Message-ID: <7gl26k$j05$2@rd1936.quicknet.nl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US