Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
Functions, 83 of 177
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
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|