Re: Multiple Insert in Oracle

ln21aib_at_btp.fac.alcatel.it (Piebro) wrote:
>Hi. I am a newbie user of Oracle and I have a trouble.
>On BTRIEVE I can
>prepare in a memory area a number of records and then make only one >INSERT operation
>to insert all records in database at same time.
>Can I do the same operation on ORACLE system ????
>Please Help Me.
>Thanks a lot.
>My email address is: ln21aib_at_fasm3c.btp.fac.alcatel.it.
>

Oracle allows what is called array processing using the Oracle Precompilers (Pro* C) or through the Oracle Call Interface (OCI).

With this, you can pass a structure of arrays, NOT AN ARRAY OF STRUCTURES, in an insert statement. Our testing has shown that array sizes of 50-100 are best. You can also use array processing for fetching data. Received on Fri Dec 01 1995 - 00:00:00 CET