![]() Previous |
![]() Next |
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
.