![]() Previous |
![]() Next |
A numeric expression evaluates to any of the numeric data types. The data in a numeric expression can be any combination of the following:
Numeric literals as discussed in "Numeric Data Types".
Numeric variables or formulas
Dimensions
Functions that yield numeric results
Date literals, variables, formulas, or functions
In addition, you can join any of these expressions with the arithmetic operators for a more complex numeric expression. You use arithmetic operators in numeric expressions with numeric data, which returns a numeric result. You can also use some arithmetic operators in date expressions with a mix of date and numeric data, to retrieve either a date or numeric result.
Several options determine how Oracle OLAP handles numeric expressions.