Oracle 插入多条记录的sql
程序员文章站
2023-12-29 08:46:22
...
插入多条记录的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