UPPER

UPPER converts all alphabetic characters in a text expression to uppercase.

Return Value

VARCHAR2 | CLOB | NVARCHAR2 | NCLOB  

Syntax

UPPER(char)

Arguments

char can be any text expression.

Example

UPPER('This is an emergency') returns the string THIS IS AN EMERGENCY.

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