The Oracle and PL/SQL LOWER function converts all letters in the specified string to lowercase.
The general format is:
LOWER(char)
Example 1:
SELECT LENGTH('JOHN WILLIAMS') FROM DUAL;
returns:
john williams
The Oracle and PL/SQL LOWER function converts all letters in the specified string to lowercase.
The general format is:
LOWER(char)
Example 1:
SELECT LENGTH('JOHN WILLIAMS') FROM DUAL;
returns:
john williams