Purpose
LOWER() converts all letters in a string to lowercase.
Syntax
LOWER(char)
Parameters
char specifies the source string. It can be of the CHAR, VARCHAR2, NCHAR, NVARCHAR2, or CLOB data type.
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 LOWER('AaBbCcDd') Lowercase FROM DUAL;
+-----------+
| LOWERCASE |
+-----------+
| aabbccdd |
+-----------+
1 row in set