Numeric Options |
A number of options determine how Oracle OLAP handles numeric expressions. These options are listed in Table: Numeric Options.
Numeric Options
| Option | Description |
|---|---|
| DECIMALOVERFLOW
|
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. |
| DIVIDEBYZERO
|
Controls the result of division by zero. |
| RANDOM.SEED.1 and RANDOM.SEED.2 | (Set only) Options that specify values used by RANDOM when computing random numbers. Typically, you only set values for these options when you are developing and debugging your application programs. |
| ROOTOFNEGATIVE
|
A flag that allows or disallows any attempt to obtain a root of a negative number. |