Numeric Expressions

---

A numeric expression evaluates to data with any of the numeric data types (that is, INTEGER, SHORTINTEGER, DECIMAL, SHORTDECIMAL, and NUMBER). The data in a numeric expression can be any combination of the following:

• Numeric literals

• Numeric variables or formulas

• Dimensions

• Functions that yield numeric results

• Date literals, variables, formulas, or functions

In addition, you can join any of these three-part 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.

A number of options determine how Oracle OLAP handles numeric expressions. These options are listed in Table: Numeric Options.