|Oracle9i SQL Reference
Release 1 (9.0.1)
Part Number A90125-01
Functions, 81 of 166
NLS_UPPER returns char, with all letters uppercase.
Both char and nlsparam can be any of the datatypes
NCLOB. The string returned is of
VARCHAR2 datatype and is in the same character set as char.
The nlsparam can have the same form and serve the same purpose as in the
The following example returns a string with all the letters converted to uppercase: