Oracle Database - NLS_NUMERIC_CHARACTERS (decimal separator and thousands separator)

Card Puncher Data Processing

About

The NLS_NUMERIC_CHARACTERS option specifies the decimal marker (of decimal separator) and thousands group marker (of group separator) for the session.

The NLS_NUMERIC_CHARACTERS is a result of the NLS_LANG setting.

The decimal character and the group separator must be two different single-byte characters, and cannot be a numeric value or any of the following characters: plus sign (“+”), less-than sign (“<”), minus sign or hyphen (“-” ), or greater-than sign (“>”).

If the decimal character is not a period (.), you must use single quotation marks to enclose all number values that appear in expressions in your SQL statements.

NLS_NUMERIC_CHARACTERS affects the display of numeric data.

Within a session, you can dynamically modify the value by using the SQL statement

ALTER SESSION SET NLS_NUMERIC_CHARACTERS = option-value 

Examples

Changing the Decimal Marker to a Comma

The following statement changes the decimal marker to a comma, and the thousands marker to a space.

ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ', '

The result of 1234.56 is now 1 234,56.

Reference

  • See Oracle Database Reference for more information about NLS initialization parameters.





Discover More
Card Puncher Data Processing
Oracle - SQL*Loader

A utility data loader for the Oracle database Reason: NLS_NUMERIC_CHARACTERS is equal to ',.' or '.,' based upon the Territory (NLS_LANG) you are in. Example: The NLS_LANG...
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 - TO_NUMBER function

The format value must have this form: 'dg' where : D is the new decimal character. G is the new group separator. Example: nls-param can be one of more NLS parameters as : , NLS_CURRENCY,...



Share this page:
Follow us:
Task Runner