--生成100以内的随机数
select round(dbms_random.value * 100 ,0) a from dual;
--生成某个范围内的随机数
select trunc(dbms_random.value(1,100)) from dual;
--生成随机字符串
DBMS_RANDOM.STRING
opt IN CHAR,
len IN NUMBER)
RETURN VARCHAR2;
'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 返回可打印的字符
SQL>SELECT DBMS_RANDOM.STRING('U', 5) U,
2 DBMS_RANDOM.STRING('L', 5) L,
3 DBMS_RANDOM.STRING('A', 5) A,
4 DBMS_RANDOM.STRING('X', 5) X,
5 DBMS_RANDOM.STRING('P', 5) P
6 FROM dual;
U L A X P
------ ------ ------ ------ ------
YCOHX zcxlm InVXi 47H10 pJ/TP