NLS_UPPER

NLS_UPPER converts all alphabetic characters in a text expression to uppercase. The data type of the return value is the same as the original text.

Return Value

CHAR | NCHAR | VARCHAR2 | NVARCHAR2

Syntax

NLS_UPPER (char [, 'nlsparam' ])

Arguments

char can be any text expression.

nlsparam is a linguistic sort sequence in the form NLS_SORT =sort[_ai |_ci], where sort is an NLS language. You can add a suffix to the language to modify the sort: _ai for an accent-insensitive sort, or _ci for a case-insensitive sort.

Example

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