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 |