Difference between Insert and Insert all
769072Aug 12 2011 — edited Aug 12 2011Hi,
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!