28 May
Multirow Inserts
While attempting to insert several rows into a table in our Oracle database, a colleague dutifully copied the exact ANSI/ISO SQL standard syntax for his purposes. Guess what happened?
INSERT INTO table (column1, column2)
VALUES (value1, value2), (value1, value2);
ERROR at line 1:
ORA-00933: SQL command not properly ended
Unlike some other databases (DB2, PostgreSQL, MySQL), Oracle doesn’t