oracle 生成 20 位随机数字的函数

发布时间：2020-12-12 16:14:03 所属栏目：百科来源：网络整理

导读：-- Create sequence create sequence SEQU_SOFA_FIDminvalue 1maxvalue 99999start with 7increment by 1cache 100cycle;CREATE OR REPLACE FUNCTION SOFA_NUID RETURN NUMBER IS RE NUMBER(20);BEGIN SELECT TO_NUMBER(TO_CHAR(SYSDATE,'YYMMDDhh24miSS') |

-- Create sequence 
create sequence SEQU_SOFA_FID
minvalue 1
maxvalue 99999
start with 7
increment by 1
cache 100
cycle;


CREATE OR REPLACE FUNCTION SOFA_NUID RETURN NUMBER IS
  RE NUMBER(20);
BEGIN
  SELECT TO_NUMBER(TO_CHAR(SYSDATE,'YYMMDDhh24miSS') ||
                   LPAD(ABS(MOD(DBMS_RANDOM.RANDOM,1000)),3,0) ||
                   LPAD(SEQU_SOFA_FID.NEXTVAL,5,0))
    INTO RE
    FROM DUAL;
  RETURN RE;
END;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!