Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Optimize Insert
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 BortelReceived on Tue Jan 11 2005 - 07:49:21 CST
![]() |
![]() |