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