Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 81 of 166
nls_upper::=
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
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|