All Products
Search
Document Center

LOWER

Last Updated: Jun 18, 2021

The LOWER function converts a string to lowercase.

Syntax

LOWER(c1)

Parameters

Parameter

Description

c1

The string. The string type can be CHAR, VARCHAR2, NCHAR, NVARCHAR2, or CLOB.

Return type

The return type is the same as the data type of c1.

Examples

Execute the following statement:

SELECT  lower('AaBbCcDd')AaBbCcDd FROM DUAL;

The following query result is returned:

+----------+
| AABBCCDD |
+----------+
| aabbccdd |
+----------+