Arithmetic Operators : Operators « PL SQL Operators « Oracle PL/SQL Tutorial

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>

23.1.Operators
	23.1.1.	Operators
	23.1.2.	The basic arithmetic operators in action
	23.1.3.	Logical Operators in PL/SQL
	23.1.4.	Running Anonymous Blocks of Code
	23.1.5.	Arithmetic Operators
	23.1.6.	Exponentiation
	23.1.7.	The negation and identity operators in action.
	23.1.8.	Comparison Operators
	23.1.9.	The Relational Operators: =, <>, !=, ~=, <, >, <=, >=
	23.1.10.	Logical Operators
	23.1.11.	String Operators
	23.1.12.	Use of Comparison Operators with Strings