Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Insert multiple rows with a single statement
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