oracle数据库实现批量插入功能

方式一：用一条查询语句查出来的结果集插入表中

insert into table(a,b) 
select a,b from (select '1' as a,'2' as b from dual union all select '3' as a,'4' as b from dual)

方式二：用多条查询语句查出来的结果集合并后插入表

insert into table(a,b) 
select '1' as a,'2' as b from dual 
union all 
select '3' as a,'4' as b from dual

方式三：用begin和end关键字拼接多行单条的插入语句

begin
    insert into table(a,b) values ('1','2');
    insert into table(a,b) values ('3','4');
end;

方式四：用insert all关键字，每条记录前面加个into，最后加一条select语句

insert all
into table(a,b) values ('1','2') 
into table(a,b) values ('3','4') 
select '1' from dual;