Quick Search:


	CODE Oracle PL/SQL Code Library


	JOBS Find Or Post Oracle Jobs


	FORUM Oracle Discussion & Chat

The Oracle NLS_LOWER Function [Return To Index]

Jump to:

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

Term: NLS_LOWER

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

Example Syntax:

NLS_LOWER(<string_or_column>);

Example Usage:

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

FROM DUAL;

PSOUG LOGIN
Username:
Password: