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 the string to return. The rules are:
|
| len | Returns the length of a string. |
Return values
| Return value | Description |
|---|---|
| VARCHAR2 | Data of the VARCHAR2 data type. |