Insert All

Insert many rows to a table/tables

Last updated: 14 December 2017

Warning: Review and test in a non-production environment before running.

Back to results

INSERT ALL

INTO TABLEA (CODE,TEUR) VALUES (1,'abc')

INTO TABLEA (CODE,TEUR) VALUES (2,'bcd')

INTO TABLEB (CODE,TEUR) VALUES (1,'abcde')

SELECT * FROM DUAL;