Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Operators

 

Arithmetic Operators

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>