LOWER

LOWER converts all alphabetic characters in a text expression to lowercase.

Return Value

VARCHAR2 | NVARCHAR2 | CLOB | NCLOB

Syntax

LOWER(char)

Arguments

char can be any text expression.

Example

LOWER('STOP SHOUTING') returns the string stop shouting.

Copyright © 2003, 2007, Oracle. All rights reserved.