1. 隨機數包

SELECT DBMS_RANDOM.VALUE

FROM DUAL;

2. 在[0..100]範圍內取隨機數

SELECT TRUNC (DBMS_RANDOM.VALUE ( 0 , 100 ))

FROM DUAL;

3. 大於字元‘A’的10個字元隨機字串

SELECT DBMS_RANDOM.STRING ( " A " , 10 )

FROM DUAL;

4. 單個小寫隨機字元

SELECT CHR ( ROUND (DBMS_RANDOM.VALUE ( 97 , 122 )))

FROM DUAL;

5. 在過去30分鐘內取隨機時間

SELECT (SYSDATE - 1 / 24 / 60 * 30 ) + DBMS_RANDOM.VALUE ( 1 , 1800 ) / 3600 / 24

FROM DUAL;