CREATE OR REPLACE PROCEDURE B() AS
DECLARE
v_id integer :=1;
BEGIN
FOR i IN 1..10 LOOP
INSERT INTO "T_BIZ_ANNOUNCEMENT"
("ANID","ANTITLE","ANCONTENT","ANTIME","ANUSERID","ANUSERNAME" )
VALUES
(v_id,'y11122222222222','1234567890123456789','2018-12-13 14:56:17.0','ac51d2c1-2590-4b2c-ac3c-aaf418954f96','test1' );
v_id := v_id+1;
END LOOP;
END;
CALL B();
如果是想参数化，数据复杂些：
CREATE OR REPLACE PROCEDURE B() AS
DECLARE
v_id integer :=1;
BEGIN
FOR i IN 1..10 LOOP
INSERT INTO "T_BIZ_ANNOUNCEMENT"
("ANID","ANTITLE","ANCONTENT","ANTIME","ANUSERID","ANUSERNAME" )
VALUES
(concat('13212356456465456-',v_id),concat('title',v_id),concat('ANCONTENT',v_id),'2018-12-13 14:56:17.0','ac51d2c1-2590-4b2c-ac3c-aaf418954f96','test1' );
v_id := v_id+1;
END LOOP;
END;
CALL B();
插入数据
CREATE OR REPLACE PROCEDURE c() AS
DECLARE
v_id integer :=1;
BEGIN
FOR i IN 1..10000 LOOP
INSERT INTO "PUBLIC"."T_BIZ_INFOREPORT"
("ID","ASKDRAFT_USER_ID","ASKDRAFT_USER_NAME","ASKDRAFT_DEPT_ID","ASKDRAFT_DEPT_NAME","ASKDRAFT_TITLE","ASKDRAFT_CONTENT","ASKDRAFT_CREATE_TIME","ASKDRAFT_FINISH_TIME","ASKDRAFT_STATUS","DRAFT_USER_ID","DRAFT_USER_NAME" )
VALUES
(concat('93c73822-aace-4e3d-b7c1-f',v_id),'b229650e-3eef-49f7-a3a6-e35e353159d3','test1','13a6728b-3fdb-46d8-89d2-003973599afe','省委机要局',concat('约稿标题t',v_id),concat('约稿内容test',v_id),'2018-12-17 10:44:21.0','2018-12-17 00:00:00.0','已约稿','4d3cc8c2-8c48-4b88-99b8-f268f1b520d1','test2');
v_id := v_id+1;
END LOOP;
END;
CALL c();
CREATE OR REPLACE PROCEDURE r() AS
DECLARE
v_id integer :=1;
BEGIN
FOR i IN 1..4000 LOOP
INSERT INTO "PUBLIC"."T_BIZ_INFOREPORT"
("ID","ASKDRAFT_USER_ID","ASKDRAFT_USER_NAME","ASKDRAFT_DEPT_ID","ASKDRAFT_DEPT_NAME","ASKDRAFT_TITLE","ASKDRAFT_CONTENT","ASKDRAFT_CREATE_TIME","ASKDRAFT_FINISH_TIME","ASKDRAFT_STATUS","DRAFT_USER_ID","DRAFT_USER_NAME" )
VALUES
(concat('93c73ceb82896-9991-4065-a233d-',v_id),'57e20146-3381-47e8-8f1d-90a71f919706','admin','13a6728b-3fdb-46d8-89d2-003973599afe','省委机要局',concat('约稿标题t',v_id),concat('约稿内容test',v_id),'2018-08-14 10:44:21.0','2018-08-14 00:00:00.0','已约稿','4d3cc8c2-8c48-4b88-99b8-f268f1b520d1','test2');
v_id := v_id+1;
END LOOP;
END;
CALL r();
CREATE OR REPLACE PROCEDURE CC IS
DECLARE
v_id integer :=1;
BEGIN
FOR i IN 1..10 LOOP
INSERT INTO T_BIZ_INFOEDIT(
ID,
EDIT_USER_ID,
EDIT_USER_NAME,
EDIT_DEPT_ID,
EDIT_DEPT_NAME,
EDIT_TITLE,
EDIT_NO,
EDIT_SECRET,
EDIT_UREGENCY,
EDIT_ATTACHMENT_UPLOAD,
EDIT_ATTACHMENT_ONLINE,
APPROVE_ROUTE,
APPROVE_USER_ID,
APPROVE_USER_NAME,
APPROVE_STATUS,
APPROVE_OPINION,
READ_ROUTE,
READ_USER_IDS,
PRINT_FORM,
INFO_STATUS,
CREATE_TIME,
UPDATE_TIME,
INFOTYPE_ID,
INFOTYPE_NAME
)
VALUES
(concat('8575d4fb-0540-48bc-a609-3',v_id),
'57e20146-3381-47e8-8f1d-90a71f919706',
'超级管理员',
'66fb1c02-9e9c-4b1b-96ee-fbea614e48ca',
'省级领导',
'xxbs111',
concat('xxcb',v_id),
'一般',
'一般',
concat(concat('/home/zbql/TongWeb6.1/deployment/inforeportSS2/upload/ec962c13-7c31-4919',v_id),'.doc'),
'null',
'相关领导批示',
'57e20146-3381-47e8-8f1d-90a71f919706',
'超级管理员',
'待审批',
'null',
'null',
'null',
'null',
'成刊',
'2018-12-01 09:08:33.0',
'2018-12-01 09:08:33.0',
'a8142c16-23ce-4403-983e-8c8ddb2c704b',
'每日情况');
v_id := v_id+1;
END LOOP;
END;
CALL CC();
