CODE EXAMPLE FOR SQL

oracle insert multiple rows into same table

INSERT INTO my_table (col1, col2)
SELECT 8000, 0 FROM DUAL
UNION ALL
SELECT 8001, 5 FROM DUAL;