|Oracle® OLAP DML Reference
11g Release 1 (11.1)
|PDF · Mobi · ePub|
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.
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.