PL/SQL Operator

---

---

PL/SQL Operator

Same Operator are supported in PL/SQL which are supported in SQL, except assignment operator. In place of assignment operator := are acting as a assignment operator in PL/SQL.

• Arithmetic Operators
• Relational Operators
• Logical Operators
• Miscellaneous Operators

Arithmetic Operators

Operator	Name	Example (int a=8, b=3)
+	Addition	a+b=11
-	Subtraction	a-b=5
*	Multiplication	a*b=24
/	Division	a/b=2
%	Modulas (Remainder)	a%4=0

Relational Operators

Operators	Description	Example: a=10, b=20
!=	Check the left operands value are not equal to right operands, if yes return true.	a!=b=True
>	Check the left operand value is greater than right Operand, if yes condition becomes true	a>b=False
<	Check the left operand value is less than right Operand, if yes condition becomes true	a<b=True
<=	Check the left operand value is less than or equal to right Operand, if yes condition becomes true	a<=b=True
>=	Check the left operand value is greater than or equal to right Operand, if yes condition becomes true	a>b=False

Logical Operator

	Operator	Description
1	AND	And are use to combined two or more than two condition together. If both the condition is true then return true.
2	OR	OR are use to combined two or more than two condition together, In this case you need at least one condition is true then return result.
3	Not	NOT operator reverse the meaning of any logical operator

Truth table of Logical Operator

C1	C2	C1 AND C2	C1 OR C2	NOT C1	NOT C2
T	T	T	T	F	F
T	F	F	T	F	T
F	T	F	T	T	F
F	F	F	F	T	T

Miscellaneous Operator

Between	Not between	In
Not in	Like	Exists
Not exists	Is null	Is not null
Any	All	Some
Union	Union all	Intersect
minus

---

---