LOWER
converts all alphabetic characters in a text expression to lowercase. The data type of the return value is the same as the original text.
CHAR | NCHAR | VARCHAR2 | NVARCHAR2
LOWER(char)
char
can be any text expression.
LOWER('STOP SHOUTING')
returns the string stop shouting
.