Lower – Oracle SQL Function

LOWER returns a string that is the same as the 1st argument with all the characters in lowercase.

The argument to LOWER can be a CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB or NCLOB.

Example:

SELECT LOWER(‘Oracle Rocks’) as RESULT FROM DUAL;

RESULT
—————-
oracle rocks