Oracle Database - Territory (NLS_TERRITORY)

Card Puncher Data Processing

About

Territory in the context of oracle database. It specifies the conventions for default date, monetary and numeric formats.

Configuration

NLS_TERRITORY

NLS_TERRITORY is a Nls Parameter that define the following parameters:

  • NLS_CURRENCY,
  • NLS_DUAL_CURRENCY,
  • NLS_ISO_CURRENCY,
  • NLS_TIMESTAMP_FORMAT,
  • NLS_TIMESTAMP_TZ_FORMAT,
  • NLS_NUMERIC_CHARACTERS

if they are not set.





Discover More
Card Puncher Data Processing
Oracle Database - Globalization (Localization, NLS parameter)

Globalization support enables the storing, processing and retrieval of data in native languages. The languages that can be stored in an Oracle database are encoded by Oracle Database-supported character...
Card Puncher Data Processing
Oracle Database - Userenv (Current Session Informations)

Userenv is a pre-build context that describes the current session. You can query the context Userenv with two functions. the SYS_CONTEXT...



Share this page:
Follow us:
Task Runner