Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Insert multiple rows with a single statement
Sashi wrote:
> All, does PL/SQL support inserting more than one row with a single
> statement, similar to what mySQL has? I looked around but couldn't
> find anything regarding this.
>
> I'm assuming that a single insert to insert, say 10,000 rows would be
> faster than 10,000 insert statements and it seems funny that multiple
> insert is not supported.
>
> Thanks,
> Sashi
In Oracle you can insert single rows
You can insert arrays
You can insert into multiple tables in a single statement
There are a lot of options.
Check these out:
http://www.psoug.org/reference/insert.html
http://www.psoug.org/reference/array_processing.html
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Aug 10 2007 - 19:08:59 CDT