Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-02 |
|
|
View PDF |
nls_upper::=
NLS_UPPER
returns char
, with all letters uppercase.
Both char
and 'nlsparam'
can be any of the datatypes CHAR
, VARCHAR2
, NCHAR
, NVARCHAR2
, CLOB
, or 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 NLS_INITCAP
function.
The following example returns a string with all the letters converted to uppercase:
SELECT NLS_UPPER ('große') "Uppercase" FROM DUAL; Upper ----- GROßE SELECT NLS_UPPER ('große', 'NLS_SORT = XGerman') "Uppercase" FROM DUAL; Upperc ------ GROSSE