Quick Search:


	CODE Oracle PL/SQL Code Library


	JOBS Find Or Post Oracle Jobs


	FORUM Oracle Discussion & Chat

The Oracle NLS_UPPER Function [Return To Index]

Jump to:

Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: NLS_UPPER

Definition:
The Oracle NLS_UPPER function returns a string with each letter converted to uppercase in the National Language character set. This function works identically to the Oracle UPPER, but with National Language Support (NLS).

Example Syntax:

NLS_UPPER(<string_or_column>);

Example Usage:

SELECT NLS_UPPER('John Smith', 'NLS_SORT = XDanish')

FROM DUAL;

PSOUG LOGIN
Username:
Password: