oracle产生随机数和随机字符串

https://blog.csdn.net/itmyhome1990/article/details/45541813

参考一下

opt Specifies what the returning string looks like:
• ‘u’, ‘U’ - returning string in uppercase alpha characters
• ‘l’, ‘L’ - returning string in lowercase alpha characters
• ‘a’, ‘A’ - returning string in mixed case alpha characters
• ‘x’, ‘X’ - returning string in uppercase alpha-numeric
characters
• ‘p’, ‘P’ - returning string in any printable characters.
Otherwise the returning string is in uppercase alpha characters.

参数为大写U或者小写u会生成指定长度的大写字母字符串
参数为大写L或者小写l会生成指定长度的小写字符字符串
参数为大写A或者小写a会生成既有大写字母又有小写字母的指定长度的字符串
参数为大写X或者小写x会生成即包含大写字母又包含数字的指定长度的字符串
参数为大写P或者小写p会生成任何可打印字符的指定长度的字符串

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

DBMS_RANDOM.STRING('P',10)
--------------------------------------------------------------------------------
~g-4~]<"X7

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

DBMS_RANDOM.STRING('A',10)
--------------------------------------------------------------------------------
mjYkIdXCTW

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

DBMS_RANDOM.STRING('L',10)
--------------------------------------------------------------------------------
qzfbvivico

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

DBMS_RANDOM.STRING('U',10)
--------------------------------------------------------------------------------
CTEOXXIBGZ

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

DBMS_RANDOM.STRING('X',10)
--------------------------------------------------------------------------------
65Z01389YQ

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

DBMS_RANDOM.STRING('X',10)
--------------------------------------------------------------------------------
6JTJYKXK42

SQL>