Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference between Insert and Insert all

769072Aug 12 2011 — edited Aug 12 2011
Hi,

I tried to understand what INSERT ALL syntax is doing, but I cannot find any difference between INSERT and INSERT ALL.

I replicated the test scenario using the data from the below mentioned URL:

http://psoug.org/reference/insert.html

I also did a google on finding up the difference between them, but could not find any...

Please advice if both are same as I have planned to use INSERT statement with a WHEN clause if INSERT ALL is same as INSERT.

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 9 2011
Added on Aug 12 2011
9 comments
7,511 views