oracle循环insert十万条数据

最新推荐文章于 2024-08-15 17:22:33 发布

原创最新推荐文章于 2024-08-15 17:22:33 发布 · 1.5k 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #数据库 #sql

oracle数据库专栏收录该内容

8 篇文章

订阅专栏

本文展示了一个使用PL/SQL进行循环批量插入数据到数据库表WR_MODEL_RESULT的示例。该过程通过声明变量n_numb并利用循环结构，连续插入记录直至变量值达到指定条件。每个插入操作包含了大量字段的设定。

declare
  n_numb number := 100000; --声明变量
begin
  while n_numb < 200000 -- 循环开始
   loop
    insert into WR_MODEL_RESULT (ID, ALERTDATE, BANKORGID, DOUFIELD1, DOUFIELD10, DOUFIELD11, DOUFIELD12, DOUFIELD13, DOUFIELD14, DOUFIELD15, DOUFIELD2, DOUFIELD3, DOUFIELD4, DOUFIELD5, DOUFIELD6, DOUFIELD7, DOUFIELD8, DOUFIELD9, INTFIELD1, INTFIELD10, INTFIELD11, INTFIELD12, INTFIELD13, INTFIELD14, INTFIELD15, INTFIELD2, INTFIELD3, INTFIELD4, INTFIELD5, INTFIELD6, INTFIELD7, INTFIELD8, INTFIELD9, MODELID, STRFIELD1, STRFIELD10, STRFIELD11, STRFIELD12, STRFIELD13, STRFIELD14, STRFIELD15, STRFIELD16, STRFIELD17, STRFIELD18, STRFIELD19, STRFIELD2, STRFIELD20, STRFIELD21, STRFIELD22, STRFIELD23, STRFIELD24, STRFIELD25, STRFIELD26, STRFIELD27, STRFIELD28, STRFIELD29, STRFIELD3, STRFIELD30, STRFIELD31, STRFIELD32, STRFIELD33, STRFIELD34, STRFIELD35, STRFIELD36, STRFIELD37, STRFIELD38, STRFIELD39, STRFIELD4, STRFIELD40, STRFIELD41, STRFIELD42, STRFIELD43, STRFIELD44, STRFIELD45, STRFIELD46, STRFIELD47, STRFIELD48, STRFIELD49, STRFIELD5, STRFIELD50, STRFIELD6, STRFIELD7, STRFIELD8, STRFIELD9, WARNINGNO)
values (n_numb, '20201231', '000000', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 12, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'C01B000000', '5', null, null, null, null, null, null, null, null, null, null, '6', null, null, null, null, null, null, null, null, null, null, '7', null, null, null, null, null, null, null, null, null, null, '8', null, null, null, null, null, null, null, null, null, null, '9', null, '10', '11', null, null, '[20201231]:[C01B000000]');
    n_numb := n_numb + 1; --变量自增
  end loop; --循环结束
end;