You can use an arithmetic operator in an expression to negate, add, subtract, multiply, and divide numeric values. The result of this operation is also a numeric value. The + and - operators are also supported in date/time fields to allow date arithmetic. The following table lists the supported arithmetic operators.

Table 1. Arithmetic Operators
Operator Purpose Example
+ - Denotes a positive or negative expression. These are unary operators. SELECT * FROM EMP WHERE COMM = -1
* / Multiplies, divides. These are binary operators. UPDATE EMP SET SAL = SAL + SAL * 0.10
+ - Adds, subtracts. These are binary operators. SELECT SAL + COMM FROM EMP WHERE EMPNO > 100