Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Using BULK BIND.....
Hi,
Have a program which is currently processing a cursor and doing various bits and bobs with the data. Am making a change in which i need to insert data into a table for each row processed.
My question is would it be better to store this info in a PLSQL table first then once the cursor has completed use a BULK BIND to insert the data into the database table in one go rather than doing an insert on each iteration of the loop.
Using Oracle 9.2 and will be several thousand rows.
Thanks Received on Thu Feb 23 2006 - 04:52:22 CST