Skip Headers
Oracle® OLAP DML Reference
10g Release 2 (10.2)

Part Number B14346-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

DECIMALOVERFLOW

The DECIMALOVERFLOW option controls the result of arithmetic operations that produce out-of-range numbers. Decimal numbers are stored as a mantissa and an exponent. Decimal overflow occurs when the result of a calculation is very large and can no longer be represented by the exponent portion of the decimal representation.

Data type

BOOLEAN

Syntax

DECIMALOVERFLOW = YES|NO

Arguments

YES

Allows overflow. A calculation that generates overflow will execute without error, and the results of the calculation will be NA.

NO

(Default) Disallows overflow. A calculation involving overflow will stop executing, and an error message will be produced.

Examples

Example 12-2 The Effect of DECIMALOVERFLOW

This example shows the effect of changing the value of the DECIMALOVERFLOW option.

When you execute a SHOW statement such as the following without changing DECIMALOVERFLOW from its default value of NO, an error occurs.

SHOW 1000000.0 ** 133

When you change DECIMALOVERFLOW to YES, the same statement executes without an error and produces NA as the result of the operation. The statements

DECIMALOVERFLOW = YES
SHOW 1000000.0 ** 133

produce the following result.

NA