您好,欢迎访问一九零五行业门户网

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 select '3', '4', '5' from dual
        union all select '4', '5', '6' from dual
        union all select '5', '6', '7' from dual

其它类似信息

推荐信息