Arithmetic operators are used for mathematical computations.
OperatorExampleUsage
**10**5The exponentiation operator. 10**5 = 100,000.
*2*3The multiplication operator. 2 * 3 = 6.
/6/2The division operator. 6/2 = 3.
+2+2The addition operator. 2+2 = 4.
-4-2The subtraction operator. 4 -2 = 2.
--5The negation operator.
++5It complements the negation operator.
The basic arithmetic operators in action.
SQL>
SQL> SET SERVEROUTPUT ON
SQL> BEGIN
2 DBMS_OUTPUT.PUT_LINE(4 * 2); --multiplication
3 DBMS_OUTPUT.PUT_LINE(24 / 3); --division
4 DBMS_OUTPUT.PUT_LINE(4 + 4); --addition
5 DBMS_OUTPUT.PUT_LINE(16 - 8); --subtraction
6 END;
7 /
8
PL/SQL procedure successfully completed.
SQL>