Oracle插入多条记录的sql
来源:动视网
责编:小采
时间:2020-11-09 11:56:13
Oracle插入多条记录的sql
Oracle插入多条记录的sql:插入多条记录的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
导读Oracle插入多条记录的sql:插入多条记录的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

插入多条记录的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
,
Oracle插入多条记录的sql
Oracle插入多条记录的sql:插入多条记录的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