Oracle 插入多条记录的sql

来源:这里教程网 时间:2026-02-27 11:20:08 作者:

插入多条记录的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

相关推荐