| Oracle® OLAP DML Reference 11g Release 2 (11.2) E17122-08 |
|
|
PDF · Mobi · ePub |
| Oracle® OLAP DML Reference 11g Release 2 (11.2) E17122-08 |
|
|
PDF · Mobi · ePub |
(Read-only) The DECIMALCHAR option is the value specified for the NLS_NUMERIC_CHARACTERS option.
DECIMALCHAR only affects the way Oracle OLAP formats numbers in output. When you format numbers for input, use a period (.) for the decimal marker. To use a different decimal marker, enclose the value in single quotes and use the TO_NUMBER function to convert the value from text to a valid number.
Example 5-18 Identifying the Decimal and Thousands Markers
The statements in this example show the DECIMALCHAR and THOUSANDSCHAR values.
The following statement might produce a comma as output.
SHOW THOUSANDSCHAR
The following statement might produce a period as output.
SHOW DECIMALCHAR
With these values, the following statement might produce the output that follows it.
SHOW TOTAL(sales) 63,181,743.50
|
 Copyright © 1994, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
