SQL LOWER Function
SQL LOWER function changes the case of a string. SQL LOWER is very simple to use and works only with character-based data types. All you need to do is pass the string that needs its case converted, and SQL LOWER function returns the same string, but with all lowercase letters.
Example:
The following code uses the SQL LOWER () function to change the case of the results from the name column:
SELECT first_name, LOWER (first_name) FROM employee;
Output:
SQL LOWER function converts all upper case letters in string to lower case; numbers and symbols are not affected. If the string argument is NULL, a NULL value is returned. If you do not provide a value for the string argument, an error will be returned.
Example 2:
The following returns the string “abcdef”.
SELECT LOWER ('ABCdef') FROM dual;
Output:
Example 3:
The following SQL LOWER function returns the string “abc123”.
SELECT LOWER ('ABC123') FROM dual;
Output:
