Array Inserts from Java JDBC
From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Fri, 1 Feb 2013 12:34:53 -0500
Message-ID: <CAE-dsOL9NyCiZuqMqLPWVCxLUyaCWBPmWXkX-k0q67gjhTx8kg_at_mail.gmail.com>
Does anyone know what JDBC syntax you use to get something equivalent to a
'forall' insert to Oracle? I googled it and there is something called a
'batch'
I talked to the developer about a jdbc feature called a 'batch insert' , but he thinks this would be 100 'insert values' statements that are bundled to reduce round trips.
Oracle 11.2.0.3
jdk 1.6
Date: Fri, 1 Feb 2013 12:34:53 -0500
Message-ID: <CAE-dsOL9NyCiZuqMqLPWVCxLUyaCWBPmWXkX-k0q67gjhTx8kg_at_mail.gmail.com>
Does anyone know what JDBC syntax you use to get something equivalent to a
'forall' insert to Oracle? I googled it and there is something called a
'batch'
I talked to the developer about a jdbc feature called a 'batch insert' , but he thinks this would be 100 'insert values' statements that are bundled to reduce round trips.
Oracle 11.2.0.3
jdk 1.6
Here is something I found on the web about batches? http://betteratoracle.com/posts/25-array-batch-inserts-with-jdbc
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 01 2013 - 18:34:53 CET