A script-enabled browser is required for this page to function properly.

Using NLS Parameters in SQL Functions

Wherever you use SQL, you can use the following NLS parameters to override default NLS behavior.

SQL Function

NLS Parameter(s)

TO_DATE

NLS_DATE_LANGUAGE

NLS_CALENDAR

TO_NUMBER

NLS_NUMERIC_CHARACTERS

NLS_CURRENCY

NLS_ISO_CURRENCY

TO_CHAR

NLS_DATE_LANGUAGE

NLS_NUMERIC_CHARACTERS

NLS_CURRENCY

NLS_ISO_CURRENCY

NLS_CALENDAR

NLS_UPPER

NLS_SORT

NLS_LOWER

NLS_SORT

NLS_INITCAP

NLS_SORT

NLSSORT

NLS_SORT