Numeric arithmetic expressions compute a value using addition, subtraction, multiplication, and division operations on numeric literals and expressions that evaluate to any numeric data type.

Syntax

 [  +  |  -  ] {  numeric_literal | numeric_expr  }
  [ {  +  |  -  |  *  |  /  } numeric_arith_expr  ]
                

Parameters

+ | -

Unary operators.

numeric_literal

Number value.

numeric_expr

Evaluates to a numeric data type:

+ | - | * | /

Operators for addition, subtraction, multiplication, and division. SQL evaluates numeric arithmetic expressions in the following order:

• Unary plus or minus
• Expressions in parentheses
• Multiplication and division, from left to right
• Addition and subtraction, from left to right