THOUSANDSCHAR

(Read-only) The THOUSANDSCHAR option is the value specified for the NLS_NUMERIC_CHARACTERS option discussed in NLS Options.

Data type

Syntax

THOUSANDSCHAR

Notes

Format for Numeric Input

The value of THOUSANDSCHAR only affects the way Oracle OLAP formats numbers in output. It does not affect the way numbers should be formatted for input.

The Decimal Marker

The DECIMALCHAR option lets you check the value of the decimal marker.

Examples

Example 23-14 Displaying the Decimal and Thousands Markers

The following statements show the DECIMALCHAR and THOUSANDSCHAR values. Assume that you issue the following statements.

SHOW THOUSANDSCHAR 
SHOW DECIMALCHAR

Assume that a comma is displayed as the marker for THOUSANDSCHAR and that a period is displayed as the marker for DECIMALCHAR. With these values, the following SHOW statement would produce the output shown below it.

SHOW TOTAL(sales)
63,181,743.50