Oracle® OLAP Expression Syntax Reference Release 11.2 Part Number E23381-01 |
|
|
PDF · Mobi · ePub |
LOWER
converts all alphabetic characters in a text expression to lowercase. The data type of the return value is the same as the original text.
CHAR | NCHAR | VARCHAR2 | NVARCHAR2
LOWER(char)
char
can be any text expression.
LOWER('STOP SHOUTING')
returns the string stop shouting
.