Oracle分批提交插入数据表，批量造数

-- Create table
create table CRM_TASK_QUEUE_BACKUP20190311
(
  l_task_id        NUMBER(25) not null,
  userid           NUMBER(25),
  vc_usr_name      VARCHAR2(40),
  vc_task_name     VARCHAR2(300) not null,
  vc_task_content  CLOB not null,
  dt_propose_time  DATE,
  dt_finish_time   DATE,
  l_urgent_type    NUMBER(2),
  c_is_done        CHAR(1),
  finisher         VARCHAR2(300),
  vc_finsher_name  VARCHAR2(400),
  l_task_order     NUMBER(25),
  l_task_score     NUMBER(4),
  dt_update_time   DATE,
  l_wk_time        NUMBER(10,2),
  vc_wk_type       VARCHAR2(50),
  dt_deadline      DATE,
  dt_estimate_time DATE,
  dt_expend_time   NUMBER(8,2),
  l_fee            NUMBER(20,2),
  dt_start_time    DATE,
  c_status         VARCHAR2(50),
  task_type1       VARCHAR2(50),
  task_type2       VARCHAR2(50),
  task_type3       VARCHAR2(50),
  remark           VARCHAR2(500)
);

declare

  a number := 0;
begin
  for i in 1 .. 1020 loop
    insert into crm_task_queue_backup20190311
      (l_task_id,
       userid,
       vc_usr_name,
       vc_task_name,
       vc_task_content,
       dt_propose_time,
       dt_finish_time,
       l_urgent_type,
       c_is_done,
       finisher,
       vc_finsher_name,
       l_task_order,
       l_task_score,
       dt_update_time,
       l_wk_time,
       vc_wk_type,
       dt_deadline,
       dt_estimate_time,
       dt_expend_time,
       l_fee,
       dt_start_time,
       c_status,
       task_type1,
       task_type2,
       task_type3,
       remark)
    values
      (seq_20190311.nextval,
       i,
       '张三' || to_char(i),
       '任务名称',
       '任务内容',
       to_date('2019/3/11 12:00:00', 'yyyy/mm/dd hh24:mi:ss'),
       to_date('2019/3/11 12:00:00', 'yyyy/mm/dd hh24:mi:ss'),
       1,
       '',
       to_char(i),
       '李四',
       1,
       20,
       to_date('2019/3/11 12:00:00', 'yyyy/mm/dd hh24:mi:ss'),
       '',
       '',
       '',
       '',
       4.55,
       6.66,
       to_date('2019/3/11 12:00:00', 'yyyy/mm/dd hh24:mi:ss'),
       to_char(i),
       'type1',
       'type2',
       'type3',
       '备注');
    a := a + 1;

--分批次提交
    if mod(a, 100) = 0 then
      commit;
    end if;
  end loop;

--最后批次的数如果不是100需要再次提交
  commit;

end;