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;