LOWER is a case manipulation function which converts all the text into lowercase. Here, text could be a column name or expression.
Here’s the syntax for Oracle LOWER function:
LOWER ( column-name/expression)
Since LOWER is a string function, it only works with string data type or text values.
LOWER function returns characters which are only in Lowercase.
Oracle LOWER Function Examples
1. Converting a simple string to lowercase
SELECT LOWER( 'WELCOME TO QUROSITY' ) FROM dual;
Result:
2. Converting the text in a column into lowercase using LOWER
Here, we use the Employee table for this:
Here’s the query:
SELECT first_name, LOWER(last_name) FROM employees;
Result:
The query returns first_name column as it is, while the last_name column is returned in all lower case.
In this tutorial, we learned to use LOWER function which is used to convert all text to lowercase.