利用dual一次性插入多条数据
oracle一次插入多条数据
标签：
oracle一次插入多条数据
insert into 表名(字段1,字段2)
2 select ‘一‘,‘二‘ from dual
3 union all
4 select ‘三‘,‘四‘ from dual
5 union all
6 select ‘五‘,‘六‘ from dual
7 union all
8 select ‘七‘,‘八‘ from dual
9 union all
10 select ‘九‘,‘十‘ from dual;