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