oracle存储过程生成uuid,存储过程 根据uuid
--porgid 父节点id ch_name 中文名 loginname 登陆id fornum 循环次数
create or replace procedure pro_test_for(porgid in varchar2,ch_name in varchar2,loginname in varchar2,fornum in number)
is
i number; --定义变量;
var_uuid varchar2(32);
begin
i:=0; --初始化为0;
--循环10000次.
for i in 1..fornum loop
--插入数据到表中.
select get_uuid into var_uuid from dual;
insert into staff values (var_uuid, loginname||i, 'e10adc3949ba59abbe56e057f20f883e', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', null, '', '8a217ca628048cae0128048d24b50001', '', ch_name||i, '', '', '', '', '', '', 0, '', '', null, '', '', '', '', '1', '', '', '', '');
insert into structure values (var_uuid, '2', ch_name||i, 1, porgid, '8a217ca628048cae0128048d24b50001,402881e82cf1dd5d012cf1e9743c0001,402881e82cf1dd5d012cf1e9c6a10003', '2202211000070003', '8a217ca628048cae0128048d24b50001', loginname||i, '');
--提交.
commit;
end loop;
end pro_test_for;