DBMS_RANDOM.STRING usage in Oracle

DBMS_RANDOM.STRING (var1, var2) in Oracle)

This function has two parameters.

The var1 parameter values include u, l, a, x, and p.

U --> uppercase

L --> lowercase

A --> mixed case

X --> uppercase, alpha & numeric

P --> any printable char

The above parameter values can also be uppercase letters, with the same effect.

Var2 indicates the length

Demo:

SELECT DBMS_RANDOM.STRING ('U', 20) from dual;
SELECT DBMS_RANDOM.STRING ('l', 20) from dual;
SELECT DBMS_RANDOM.STRING ('A', 20) from dual;
SELECT DBMS_RANDOM.STRING ('x', 20) from dual;
SELECT DBMS_RANDOM.STRING ('P', 20) from dual;