-- 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;