NLS_UPPER

Syntax

Purpose

NLS_UPPER returns char, with all letters uppercase. The 'nlsparam' can have the same form and serve the same purpose as in the NLS_INITCAP function.

Example

SELECT NLS_UPPER
   ('große', 'NLS_SORT = XGerman') "Uppercase"
     FROM DUAL;

Upper
-----
GROSS 

See Also: "NLS_INITCAP".