René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

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:
  • Arabic Hijrah
  • English Hijrah
  • Gregorian
  • Japanese Imperial
  • Persian
  • ROC Official
  • Thai Buddha

NLS_COMP

Allowed values: ansi and binary.

NLS_CURRENCY

NLS_DATE_FORMAT

Sets the default date format. See also datetime format elements.

NLS_DATE_LANGUAGE

NLS_DUAL_CURRENCY

NLS_ISO_CURRENCY

NLS_LANGUAGE

NLS_LENGTH_SEMANTICS

NLS_NCHAR_CONV_EXCP

NLS_NUMERIC_CHARACTERS

NLS_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_TERRITORY

NLS_TIME_FORMAT

NLS_TIME_TZ_FORMAT

NLS_TIMESTAMP_FORMAT

NLS_TIMESTAMP_TZ_FORMAT