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: Insert multiple rows with a single statement

Re: Insert multiple rows with a single statement

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 10 Aug 2007 17:08:59 -0700
Message-ID: <1186790938.100142@bubbleator.drizzle.com>


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.org
Received on Fri Aug 10 2007 - 19:08:59 CDT

Original text of this message

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