Bulk Insertion - INSERT ALL

 

ALTER SESSION SET CURSOR_SHARING = FORCE;

1. INSERT ALL
2. INTO my_table (column1, column2, column_n) VALUES (expr1, expr2, expr_n)
3. INTO my_table (column1, column2, column_n) VALUES (expr1, expr2, expr_n)
4. INTO my_table2 (column1, column2, column_n) VALUES (expr1, expr2, expr_n)
5. INTO my_table3 (column1, column2, column_n) VALUES (expr1, expr2, expr_n)
6. WHEN CONDITION THEN
7. INTO my_table4 (column1, column2, column_n) VALUES (expr1, expr2, expr_n)
8. SELECT * FROM dual;