Oracle LOWER() Function

Oracle LOWER() is a built-in function that returns the lowercase form of the given string.

If you need to convert a string to uppercase, use the UPPER() function instead.

Oracle LOWER() Syntax

Here’s the syntax for the Oracle LOWER() function:

LOWER(str)

Parameters

str

Required. The string to convert to lowercase. It can be of type CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB.

Return Value

The Oracle LOWER() function returns the given string in lowercase form.

If any argument is NULL, LOWER() will return NULL.

Oracle LOWER() Examples

Here are some examples of how to use the Oracle LOWER() function.

Basic Usage

To convert Hello World to lowercase, use the following statement:

SELECT
    LOWER('Hello World') Result
FROM dual;

Output:

RESULT
______________
hello world

NULL Argument

If any argument is NULL, LOWER() will return NULL.

SET NULL 'NULL';
SELECT
    LOWER(NULL)
FROM dual;

Output:

LOWER(NULL)
______________
NULL

In this example, we use the statement SET NULL 'NULL'; to display NULL values as the string 'NULL'.

Conclusion

Oracle LOWER() is a built-in function that returns the lowercase form of the given string.