Arithmetic operators
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 8.1
- Documentation
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 describes the supported arithmetic operators.
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; |