PL SQL Operators Oracle PLSQL Tutorial

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>