CREATE OR REPLACE
function getEAC001 return varchar2 is/*生成EAC001,规则:大写字母c+当前注册时间到秒20170804112040加6位随机数字码 */
Result varchar2(32);
i number(10):=0;
begin
Result:='C' || to_char(sysdate,'yyyyMMddHH24miss');
while i < 6 loop
Result:=Result || trunc(dbms_random.value(0,10));
i := i + 1;
end loop;
return(Result);
end getEAC001;
orcle数据库生成随机数字
最新推荐文章于 2024-07-22 15:12:37 发布