w3resource

Oracle LOWER function

Description

The Oracle LOWER() function returns a specified character expression in lowercase letters.

Syntax:

LOWER(cExpression)

Parameters:

Name Description Data Types
cExpression The given character expression. CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB

Return Value Type

CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB

Note: For linguistic-sensitive uppercase and lowercase, refer to NLS_INITCAP.

Applies to

Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i

Pictorial Presentation

Oracle Lower function pictorial presentation

Examples: Oracle LOWER function

The following example returns the first name of the employees in lower case.

Sample table: employees


SQL> SELECT LOWER(first_name) FROM employees;

Output :

LOWER(FIRST_NAME)
--------------------
ellen
sundar
mozhe
david
hermann
shelli
amit
elizabeth
sarah
david
......

Previous: INITCAP
Next: LPAD



Share this Tutorial / Exercise on : Facebook and Twitter