Re: multiple inserts in a single sql statement

From: Philippe <parnaud_at_yahoo.com>
Date: Wed, 10 Mar 1999 11:45:14 +0100
Message-ID: <7c5igd$d3p$1@concorde.ctp.com>

You can send a Pl/sql block :

Begin

   Insert into mytable1(col1,col2,...) values (val1,val2,...);
   Insert into mytable2(col1,col2,...) values (val1,val2,...);
   Insert into mytable3(col1,col2,...) values (val1,val2,...);
   Insert into mytable4(col1,col2,...) values (val1,val2,...);

end;

HTH Philippe

rachamallu_reddy_at_my-dejanews.com wrote in message <7c3rna$s3a$1_at_nnrp1.dejanews.com>...
>Hi,
>
>My application talks to Oracle8 via JDBC1.2. In the application, I do a lot
of
>inserts. Right now I have a sql statement for every insert. This means JDBC
>calls for every insert. With this scenario, the performance is not good.
>
>With JDBC2.0, I can batch a set of sql statements, before sending them over
to
>the server.
>
>I don't want to use JDBC2.0 now. Until then, is there any way to send
multiple
>insert's as a single sql statement?
>
>Any insight will be really appreciated.
>
>thanks
>reddy
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Mar 10 1999 - 04:45:14 CST