search

brianc / node-sql

SQL generation for node.js
MIT License
1.05k stars 191 forks source link

Improve oracle bulk inserts #388

Open JessieAMorris opened 6 years ago

JessieAMorris commented 6 years ago

Oracle uses a

INSERT ALL
   INTO "table" ("column") VALUES ("value")
   INTO "table" ("column") VALUES ("value2")
SELECT * FROM dual;

syntax instead of the standard syntax of

INSERT INTO "table" ("column") VALUES ("value"), ("value2");

This pull request changes bulk inserts for Oracle to use the proper oracle specific (👎 ) syntax.