Purpose
The LOWER function converts all uppercase letters in a string to lowercase.
Syntax
LOWER(char)
Parameters
char specifies the string. The string can be of type CHAR, VARCHAR2, NCHAR, NVARCHAR2, or CLOB.
Return type
The return type is the same as the char parameter.
Examples
Convert all uppercase letters in the string AaBbCcDd to lowercase.
obclient> SELECT LOWER('AaBbCcDd') Lowercase FROM DUAL;
+-----------+
| LOWERCASE |
+-----------+
| aabbccdd |
+-----------+
1 row in set