Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
(Read-only) The THOUSANDSCHAR option is the value specified for the NLS_NUMERIC_CHARACTERS option discussed in NLS Options.
Note:
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.ID
THOUSANDSCHAR
Example 5-105 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, a SHOW TOTAL(sales)
statement would produce the following output.
63,181,743.50