oracle insert multiple rows into same table

Solutions on MaxInterview for oracle insert multiple rows into same table by the best coders in the world

showing results for - "oracle insert multiple rows into same table"
Sasha
17 Oct 2020
1INSERT INTO my_table (col1, col2)
2SELECT 8000, 0 FROM DUAL
3UNION ALL
4SELECT 8001, 5 FROM DUAL;