人大金仓 创建表空间_人大金仓数据库-----存储过程插入1万条数据

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