[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
SQR for Bulk Inserts
- Subject: SQR for Bulk Inserts
- From: bdpecci@AEP.COM
- Date: Wed, 9 Feb 2000 09:35:50 -0500
I'm told that in 'C' I could load an array with many rows of data to be inserted
and pass the array to an insert statement as a bind variable. Oracle apparently
knows when it sees the array as the bind variable it should insert multiple rows
at the same time. I've been told this greatly improves performance.
Has anyone ever used SQR to perform bulk inserts in Oracle?