Oracle插入多条记录的sql-mysql教程

插入多条记录的sql语句--Oracle insert into db(id, zgbh, shbzh) select

insert
into db(id, zgbh, shbzh)
select '1', '2', '3' from dual
union all select '2', '3', '4' from dual
union all select '3', '4', '5' from dual
union all select '4', '5', '6' from dual
union all select '5', '6', '7' from dual