|Oracle® OLAP DML Reference
11g Release 2 (11.2)
Part Number E17122-05
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.
Example 5-106 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.