记录一下oracle批量添加测试数据
DECLARE 先定义变量
useruuid := 赋值时不要忘了冒号 :
--创建变量 useruuid
DECLARE
useruuid varchar2(200);
BEGIN
FOR i IN 1..1000 LOOP
useruuid := rawtohex(sys_guid());
INSERT INTO DPS_USER (userid, USERDISPLAYNAME, USERNAME) VALUES (useruuid, '张三-B' || i, '张三-b' || i);
INSERT INTO DPS_SE_ROLE_USER (id, roleid, userid) VALUES (rawtohex(sys_guid()), '8ce9401f-1417-4a7d-8ebb-86358facf698', useruuid);
END LOOP;
END;