INSERT ALL requires a SELECT subquery. To get around that, SELECT 1 FROM DUAL is used to give a single row of dummy data.
–
Markus JarderotJun 25 '13 at 8:17

4

How does this differ from multiple insert statements? You still have the repetition on the column names so don't seem to gain much.
–
Burhan AliMar 21 '14 at 12:32

4

Around 10-12 Multiple INSERT statements get completed in 2secs on my PC, while the above syntax is able to INSERT 1000 records per sec! Impressed! Note that I COMMIT only at the end.
–
Kent PawarApr 22 '14 at 21:30