declare
i int ;
j int ;
autoBOSSREQID NUMBER(21);
autoIDV VARCHAR2(32);
autoPKGSEQ VARCHAR2(40);
autoSEQ VARCHAR2(32);
tmp NUMBER(8);
begin
i := 0 ;
j := 0 ;
for i in 1..10 loop
tmp := to_char( i ) ;
autoBOSSREQID := to_char(142963550+ tmp) ;
autoIDV := to_char(8613800000000 + tmp) ;
autoPKGSEQ:= '025BIP2B' || to_char(25520111217101010000000 + tmp) ;
autoSEQ:='025BIP2B' || to_char(25520111217101010000000 + tmp) ;
insert into lcmcc_boss_reqinfo (BOSSREQID, PKGSEQ, RECID, RECNUM, IDV, OPR, OPRT, BIZTYPE, BILLFLG, SEQ, SPID, BIZCODE, NODEID, CREATETIME, STATUS, LASTOPERTIME, THRDNUM, TRANSIDO, ACTIVITYCODE, RESULTCODE)
values (autoBOSSREQID, autoPKGSEQ, 0, 1, autoIDV, '06', '20111217101010', 28, 2, autoSEQ, '000001', '500231873000', 'sis02', to_date('26-11-2013 10:00:41', 'dd-mm-yyyy hh24:mi:ss'), 0, to_date('26-11-2013 10:00:41', 'dd-mm-yyyy hh24:mi:ss'), '0', '', 'T2101214', '');
j := j+1;
if j > 1000 then
commit ;
j := 0 ;
end if ;
end loop ;
commit ;
end;
/
