Script error - Inserting multiple rows in one SQL statement.

[Former Member]

Hi,

Tried using INSERT ALL INTO command inside Script. But getting below error.

Oracle <> error message for operation <OCIStmExecute>: <ORA-00928: missing SELECT keyword>.

Same query with single insert statement runs fine without any issues.

Oracle eg:

INSERT ALL

    INTO item (title) VALUES ('title5')

    INTO item (title) VALUES ('title6')

    INTO item (title) VALUES ('title7')

SELECT * FROM dual;

Appreciate your suggestions.

Thx

[Former Member · Accepted solution]

Any suggestions ??

[Former Member · Accepted solution]

Hi,

Actual syntax is as below:

INSERT ALL

  INTO suppliers (supplier_id, supplier_name) VALUES (1000, 'IBM')

  INTO suppliers (supplier_id, supplier_name) VALUES (2000, 'Microsoft')

  INTO suppliers (supplier_id, supplier_name) VALUES (3000, 'Google')

SELECT * FROM dual;

Now in your non working query, you have applied comma after first INTO statement.

Please remove it.

Thanks,

Swapnil

[Former Member · Accepted solution]

Thanks @Swapnil. the query worked.