ひとつのSQLで複数行挿入

-- MySQL ではこんな感じ
insert into table1 (row1, row2, row3) values ('111', 'aaa', 'aaa'), ('222', 'bbb', 'bbb')

-- Oracle ではこんな感じ
insert all
into table1 (row1, row2, row3) values ('111', 'aaa', 'aaa')
into table1 (row1, row2, row3) values ('222', 'bbb', 'bbb')
select * from dual