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;


Related Links:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 146 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?