Neoview SQL Reference Manual (R2.4 SP2)

Numeric Value Expressions
• “Considerations for Numeric Value Expressions”
• “Examples of Numeric Value Expressions”
The operands of a numeric value expression can be combined in specific ways with arithmetic
operators. In this syntax diagram, the data type of a term, factor, or numeric primary is numeric.
numeric-expression is:
numeric-term
| numeric-expression + numeric-term
| numeric-expression - numeric-term
numeric-term is:
numeric-factor
| numeric-term * numeric-factor
| numeric-term / numeric-factor
numeric-factor is:
[+|-] numeric-primary
| [+|-] numeric-primary ** numeric-factor
numeric-primary is:
unsigned-numeric-literal
| column-reference
| numeric-type-host-variable
| dynamic parameter
| numeric-value-function
| aggregate-function
| sequence-function
| scalar-subquery
| CASE-expression
| CAST-expression
| (numeric-expression)
| OLAP-window-function
As shown in the preceding syntax diagram, numeric value expressions are built from operands
that can be:
• Numeric literals
• Column references with numeric values
• Dynamic parameters
• Numeric value functions
• OLAP window functions
• Aggregate functions, sequence functions, scalar subqueries, CASE expressions, or CAST
expressions that return numeric values
Expressions 253