Oracle random number, random date and time, random string

1. Random Number package

SELECT DBMS_RANDOM.VALUE
From dual;

2. Random Number in the range of [0 .. 100]

Select trunc (DBMS_RANDOM.VALUE (0,100 ))
From dual;

3. A 10-character random string larger than 'A'

SELECT DBMS_RANDOM.STRING ('A', 10)
From dual;

4. A single lowercase random character

Select chr (ROUND (DBMS_RANDOM.VALUE (97,122 )))
From dual;

5. Get the random date in the past 10 days

SELECT TO_DATE (TRUNC (DBMS_RANDOM.VALUE (TO_NUMBER (TO_CHAR (SYSDATE-10,
'J'
)
),
TO_NUMBER (TO_CHAR (SYSDATE, 'J '))
)
),
'J'
)
From dual;

 

6. Random Time in the past 30 minutes

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