- DECLARE --声明函数
- i INT;
- BEGIN
- i:=10;
- WHILE(i<10000)
- LOOP --设置loop循环
- i:=i+1;
- INSERT INTO PROJECT_ITEM (ID, CODE, VERSION, FOLDER_CODE, NAME, TYPE, ASSORT, PROGRESS, REGION_CODE, REGION_NAME, ORG_CODE, ORG_NAME, AGENT_CODE, AGENT_NAME, OBJECT, CONDITIONS, SCOPE, KIND, LAW_TIME, AGREE_TIME, ACCEPT_TIME, SEND_TIME, TOTAL_SIZE, IS_RATE, IS_CHARGE, IS_ONLINE, IS_FRONT, IS_PUBLIC, IS_PROCEDURE, PROCEDURE_NAME, PROCEDURE_TIME, IS_CATALOG, PAY_ONLINE, CONSULT_ONLINE, COMPLAIN_PHONE, WINDOW_PROCESS, ONLINE_PROCESS, POWER_PROCESS, TITLE_NAME, FUND_ACCOUNT, RELIEF_WAY, SORT_ORDER, CREATOR, CREATE_TIME, LAST_EDITOR, LAST_TIME, REMARK, PROPERTY, STATE, STATUS, FORM_KEYS, PROCEDURE_CODE, KIND_NAME, IS_COMPLE_FLOW, OLDITEMID, SERVICE_OBJECT, SERVICE_OBJECT_TYPE, XK_ITEM_PROPERTY, IS_AGENCYORGAN, TITLE_CODE, MODLE_ID)
- VALUES('a94a341d2a3b4d25bd6212a1'||i,'370000-SDGT-XK-'||i||'-'||i,1,'370000-SDGT-XK-'||i,'批量新增测试事项'||i,'XK','1',null,'370000000000','山东省','SD370000GT','山东省国土资源厅','SD370000GT','山东省国土资源厅',null,null,null,null,40,20,null,null,0,'0','0','0',null,'0','0',null,0,'0','0','0',null,null,null,null,null,null,null,'00001',null,TIMESTAMP '2015-05-24 13:01:09',null,TIMESTAMP '2015-07-23 09:37:37','无','0','5','5',null,null,null,null,null,'1',null,0,null,null,null);END LOOP;
- COMMIT; --循环执行完后进行提交
- END;
- 备注:i变量可以通过"||"拼接到value中。
来源: http://www.bubuko.com/infodetail-1999770.html