René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
NLS_* related initialization parameters | ||
The NLS_ related initialization parameters are exposed through v$nls_parameters .
NLS_CALENDAR
NLS_CALENDAR can be set to any of the following values:
NLS_COMP
Allowed values:
ansi and binary .
NLS_CURRENCYNLS_DATE_FORMAT
Sets the default date format. See also datetime format elements.
NLS_DATE_LANGUAGENLS_DUAL_CURRENCYNLS_ISO_CURRENCYNLS_LANGUAGENLS_LENGTH_SEMANTICSNLS_NCHAR_CONV_EXCPNLS_NUMERIC_CHARACTERSNLS_SORT
Find allowed sort names here.
In Oracle 10g, _ci can be appended to a sort name in order to
search in a case sensitive manner.
nls_comp must then be set to
ansi
NLS_TERRITORYNLS_TIME_FORMATNLS_TIME_TZ_FORMATNLS_TIMESTAMP_FORMATNLS_TIMESTAMP_TZ_FORMAT |