Purpose
NLS_LOWER() converts all letters in a string to lowercase.
Syntax
NLS_LOWER(char [, 'nlsparam' ])
Parameters
| Parameter | Description |
|---|---|
| char | The string to be converted. It can be of the CHAR, VARCHAR2, NCHAR, NVARCHAR2, or CLOB data type. |
| nlsparam | The sort order of the returned string. This parameter is optional. Note: The current version of OceanBase Database does not support this parameter. |
Return type
The return type is the same as the data type of char.
Examples
The following example converts all letters in AaBbCcDd to lowercase.
obclient> SELECT NLS_LOWER('AaBbCcDd') Lowercase FROM DUAL;
+-----------+
| LOWERCASE |
+-----------+
| aabbccdd |
+-----------+
1 row in set