Oracle dbms_random.string生成随机字符

Oracle dbms_random.string生成随机字符 

dbms_random.string(parameter,length)

parameter列表 说明  及 实例 

1.'u', 'U' - Returning string is in uppercase alpha characters. 生成由大写字母组成的随机字符

SQL> select dbms_random.string('u',64) from dual;

DBMS_RANDOM.STRING('U',64)

--------------------------------------------------------------------------------

CKLERYSHBIXVBTXCITIFOKIBVEKTWHCJCRIHFVLSISNOOWFJPDEETGLYPVXNFVQD

SQL> select dbms_random.string('U',64) from dual;

DBMS_RANDOM.STRING('U',64)

--------------------------------------------------------------------------------

ZFCHOIVQLVUCHNLLIOXPNNHRNFULQBWIXQVCEAABZYGAUWJXKVCSJYVNLXSFKRZJ

2.'l', 'L' - Returning string is in lowercase alpha characters. 生成由小写字母组成的随机字符

SQL> select dbms_random.string('l',64) from dual;

DBMS_RANDOM.STRING('L',64)

--------------------------------------------------------------------------------

lpflolminepikrpxaxdzarvjnoioszkkolmiiwfxzsbtpklmuwfkjvsydnaglxtb

SQL> select dbms_random.string('L',64) from dual;

DBMS_RANDOM.STRING('L',64)

--------------------------------------------------------------------------------

qbqsovvapftpchvhknzbucjszmottyzptrmefgmjbyamcogobzifzctpofmhuupj

3.'a', 'A' - Returning string is in mixed-case alpha characters. 生成由大小写字母混合组成的随机字符

SQL> select dbms_random.string('a',64) from dual;

DBMS_RANDOM.STRING('A',64)

--------------------------------------------------------------------------------

HMjRdhHwNiVRhrGxfGVOJbNhwFtmaSVINSMeLTxRLSfqPgKVEjVPsFSEScEDAdEa

SQL> select dbms_random.string('A',64) from dual;

DBMS_RANDOM.STRING('A',64)

--------------------------------------------------------------------------------

AivsKDOrYAEYIYDBpPCTYoMfvRiMwBrMAbiZkZNdkaoAdVFHrGXZRRGwzeEGFGEZ

'x', 'X' - Returning string is in uppercase alpha-numeric characters. 生成由大写字母数字混合组成的随机字符

SQL> select dbms_random.string('x',64) from dual;

DBMS_RANDOM.STRING('X',64)

--------------------------------------------------------------------------------

V7RBJBNGGZJWNM81HVYQ2Q7BWYG013QX5SSNUWZIYV4NP0N13F1UISOS68CLEDDM

SQL> select dbms_random.string('X',64) from dual;

DBMS_RANDOM.STRING('X',64)

--------------------------------------------------------------------------------

RCJII8JFR3ESQUC0DIUKVEPB05999D5P7N5787GUIGM8N1SJQ76AS3YSHSRRMO5Y

4.'p', 'P' - Returning string is in any printable characters. 生成由任何可打印字符组成的随机字符

SQL> select dbms_random.string('p',64) from dual;

DBMS_RANDOM.STRING('P',64)

--------------------------------------------------------------------------------

gT |$mqvzNlRINsh@HR$M)OcKv~stZn9 ]4ap\Kaa|m4XoSo4;m*j]`3L~qxI`0z

SQL> select dbms_random.string('P',64) from dual;

DBMS_RANDOM.STRING('P',64)

--------------------------------------------------------------------------------

,"4:,@K"E@8&x#S`3l}`9OML\'[;>\]n "Nd0~qZ\'1da4t_loZc1^Hi)pUJ|)qF

5.Otherwise the returning string is in uppercase alpha characters. 生成大写字母组合的随时字符

SQL> select dbms_random.string('q',64) from dual;

DBMS_RANDOM.STRING('Q',64)

--------------------------------------------------------------------------------

JTUCAKHVXEKYSJDLXGZNHBPCWBEDCSAAVZVSQENSAARXAOFACOYHEMNGUZGDDIWS

注意paramter参数的长度 只能是1位，超过1位提示错误

SQL> select dbms_random.string('as',64) from dual;

select dbms_random.string('asdf',64) from dual

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-06512: at "SYS.DBMS_RANDOM", line 171

SQL> select dbms_random.string('as',64) from dual;

select dbms_random.string('as',64) from dual

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-06512: at "SYS.DBMS_RANDOM", line 171

--刘轶鹤

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！