Oracle插入数据每5000条提交一次

declare
  i_count int;
  i_large int;
begin
  i_count := 1;
  select ceil(count(1) / 5000)
    into i_large
    from tablename ch;
  while i_count <= i_large loop 
   
    update tablename a
       set a.aa   = i_count
       where a.aa is  null
       and rownum <= 5000;
      
    commit;
    i_count := i_count + 1;
  end loop;
end;
Logo

为开发者提供学习成长、分享交流、生态实践、资源工具等服务,帮助开发者快速成长。

更多推荐