The STRING function generates a random string.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_RANDOM.STRING
opt IN CHAR,
len IN NUMBER)
RETURN VARCHAR2;
Parameters
| Parameter | Description |
|---|---|
| opt | Specifies what the returned string looks like. The rules are:
|
| len | The length of the returned string. |
Return values
| Parameter | Description |
|---|---|
| VARCHAR2 | Data of the VARCHAR2 data type. |