You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The raw query syntax for batch insertion in Oracle would be
INSERT ALL
INTO table (column1, column2, column_n) VALUES (value_1, value_2, value_3)
INTO table (column1, column2, column_n) VALUES (value_1, value_2, value_3)
INTO table (column1, column2, column_n) VALUES (value_1, value_2, value_3)
SELECT * FROM dual;
This is the code below which i tried to generate query for bulk insert
oracle_query = OracleQuery.into(table_to_insert).columns(*raw_query_col_names)
for each_row in batch:
# do_something
oracle_query = oracle_query.insert(tuple(each_row_to_insert))
But the generated raw query is: INSERT INTO "table_name" ("column_1","column_2") VALUES ('value_1','value_2'),('value_1','value_2'),('value_1','value_2')
Since it is an incorrect query, I get the error ORA-00933: SQL command not properly ended
Does it have support for this out of the box?
The text was updated successfully, but these errors were encountered:
The raw query syntax for batch insertion in Oracle would be
This is the code below which i tried to generate query for bulk insert
But the generated raw query is:
INSERT INTO "table_name" ("column_1","column_2") VALUES ('value_1','value_2'),('value_1','value_2'),('value_1','value_2')
Since it is an incorrect query, I get the error
ORA-00933: SQL command not properly ended
Does it have support for this out of the box?
The text was updated successfully, but these errors were encountered: