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;

利用dual一次性插入多条数据

oracle一次插入多条数据

标签：