需求:今天经理让我,测试跑1000个批次,每个批次1条数据
Declare
CRU_COUNTER Number(3):=1;
MIN_COUNTER Number(3):=1;
MAX_COUNTER Number(3):=999;
sname NUMBER DEFAULT 0;
Begin
For CRU_COUNTER In MIN_COUNTER..MAX_COUNTER Loop
SELECT IMG_SEQ.NEXTVAL INTO sname FROM DUAL;
insert into imageindexnew (imgid,imageid,mainindex,busitypeid,doctypeid,scandate,scanoperid,scannetid,savestatus,imagesize,isback,displayang,randdir,extendid,filename,pathname,synflag,branchid)
select IMG_SEQ.NEXTVAL,IMG_SEQ.NEXTVAL,'AAZ0000'||sname,'1','185',to_date('2013-5-2 09:57:30','YYYY-MM-DD HH:Mi:SS'),'CHS01234','A010100','O',47447,'N' ,'0','ZI','001','00A010100000000015648243','2013020502A01A010100ZI','1007','A010100'
from dual;
insert into imageindexnew (imgid,imageid,mainindex,busitypeid,doctypeid,scandate,scanoperid,scannetid,savestatus,imagesize,isback,displayang,randdir,extendid,filename,pathname,synflag,branchid)
select IMG_SEQ.NEXTVAL,IMG_SEQ.NEXTVAL,'AAZ0000'||sname,'1','185',to_date('2013-5-2 09:57:30','YYYY-MM-DD HH:Mi:SS'),'CHS01234','A010100','O',47447,'N' ,'0','ZI','001','00A010100000000015648244','2013020502A01A010100ZI',1007,'A010100'
from dual;
insert into imageindexnew (imgid,imageid,mainindex,busitypeid,doctypeid,scandate,scanoperid,scannetid,savestatus,imagesize,isback,displayang,randdir,extendid,filename,pathname,synflag,branchid)
select IMG_SEQ.NEXTVAL,IMG_SEQ.NEXTVAL,'AAZ0000'||sname,'1','185',to_date('2013-5-2 09:57:30','YYYY-MM-DD HH:Mi:SS'),'CHS01234','A010100','O',47447,'N' ,'0','ZI','001','00A010100000000015648245','2013020502A01A010100ZI',1007,'A010100'
from dual;
insert into imageindexnew (imgid,imageid,mainindex,busitypeid,doctypeid,scandate,scanoperid,scannetid,savestatus,imagesize,isback,displayang,randdir,extendid,filename,pathname,synflag,branchid)
select IMG_SEQ.NEXTVAL,IMG_SEQ.NEXTVAL,'AAZ0000'||sname,'1','185',to_date('2013-5-2 09:57:30','YYYY-MM-DD HH:Mi:SS'),'CHS01234','A010100','O',47447,'N' ,'0','ZI','001','00A010100000000015648246','2013020502A01A010100ZI',1007,'A010100'
from dual;
insert into imageindexnew (imgid,imageid,mainindex,busitypeid,doctypeid,scandate,scanoperid,scannetid,savestatus,imagesize,isback,displayang,randdir,extendid,filename,pathname,synflag,branchid)
select IMG_SEQ.NEXTVAL,IMG_SEQ.NEXTVAL,'AAZ0000'||sname,'1','186',to_date('2013-5-2 09:57:30','YYYY-MM-DD HH:Mi:SS'),'CHS01234','A010100','O',47447,'N' ,'0','ZI','002','00A010100000000015648247','2013020502A01A010100ZI',1007,'A010100'
from dual;
commit;
End Loop;
End;
/
最终:999个批次,每个批次下2个资料类型5条记录