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

Insert multiple rows with a single statement

From: Sashi <smalladi_at_gmail.com>
Date: Fri, 10 Aug 2007 12:12:02 -0700
Message-ID: <1186773122.635738.275970@d30g2000prg.googlegroups.com>


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 Received on Fri Aug 10 2007 - 14:12:02 CDT

Original text of this message

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