oracle insert into 多条数据

mysql : insert into tablename (column1,column2) values
('aa','bb'),
('dd','cc'),
('ee','ff');


oracle:insert all into tablename (column1,column2) values ('aa','bb')
into tablename (column1,column2) values ('dd','cc')
into tablename (column1,column2) values ('ee,'ff')
select 1 from dual;

原文地址:https://www.cnblogs.com/gavinYang/p/11199524.html