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;