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;