Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Optimize Insert

Re: Optimize Insert

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 11 Jan 2005 14:49:21 +0100
Message-ID: <cs0lf6$qrf$1@news5.zwoll1.ov.home.nl>


Sascha Bahl wrote:
> Hello!
>
> How can i optimize inserts into table? Under MySQL i can use value lists
> to collect many of records. How can i insert many of record in one
> insert statement?
>
> Thanks
>
> Sascha Bahl

Did you check the INSERT statement logic? http://docs.oracle.com Insert into table_name ([col1][,column_names]) select [set matching earlier columns] from another_table;

-- 
Regards,
Frank van Bortel
Received on Tue Jan 11 2005 - 07:49:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US