Oracle Database - NLS_NUMERIC_CHARACTERS

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 

Changing the Decimal Marker to a Comma

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

NLS_NUMERIC_CHARACTERS = ', '

The result of the following statement

show 1234.56

is now

1 234,56

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