Home » Oracle SQL » Oracle LOWER

Oracle LOWER

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:

Convert String to Lowercase Oracle Query

2. Converting the text in a column into lowercase using LOWER

Here, we use the Employee table for this:

Employee Table from HR Schema

Here’s the query:

SELECT first_name, LOWER(last_name) 
FROM employees;

Result:

Convert values in column to lowercase oracle sql query

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.