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;

 

posted @ 2019-07-17 10:47  努力挣扎的小兵  阅读(9044)  评论(0编辑  收藏  举报