skip to main content
Operators : Arithmetic operators
 

Arithmetic operators

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.
 
Table 5: 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;