23. 1. 5. Arithmetic Operators |
|
Arithmetic operators are used for mathematical computations. |
Operator | Example | Usage | ** | 10**5 | The exponentiation operator. 10**5 = 100,000. | * | 2*3 | The multiplication operator. 2 * 3 = 6. | / | 6/2 | The division operator. 6/2 = 3. | + | 2+2 | The addition operator. 2+2 = 4. | - | 4-2 | The subtraction operator. 4 -2 = 2. | - | -5 | The negation operator. | + | +5 | It 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
8
8
8
PL/SQL procedure successfully completed.
SQL>
|
|