https://stackoverflow.com/questions/39576/best-way-to-do-multi-row-insert-in-oracle
1 批量insert
方式一:
insert into table_name(column1,column2,..)
select value1,value2,... from dual
union all select value11,value12,.. from dual
方式二
insert all
into table_name (col1,col2,...) values (val1,val2,..)
into table_name(col1,col2,...) values (val11,val12,..)
...
select 1 from dual;
方式三:
begin
insert into table_name (col1,col2,...) values (val1,val2,..);
insert into table_name(col1,col2,...) values (val11,val12,..);
end;
oracle不支持:
insert into table_name (col1,col2,...) values (val1,val2,..);
insert into table_name(col1,col2,...) values (val11,val12,..);
...