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

OperatorNameExample (int a=8, b=3)
-Subtractiona-b=5
*Multiplicationa*b=24
/Divisiona/b=2
%Modulas (Remainder)a%4=0

Relational Operators

OperatorsDescriptionExample: 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 truea>b=False
<Check the left operand value is less than right Operand, if yes condition becomes truea<b=True
<=Check the left operand value is less than or equal to right Operand, if yes condition becomes truea<=b=True
>=Check the left operand value is greater than or equal to right Operand, if yes condition becomes truea>b=False

Logical Operator

OperatorDescription
1ANDAnd are use to combined two or more than two condition together. If both the condition is true then return true.
2OROR 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.
3NotNOT operator reverse the meaning of any logical operator

Truth table of Logical Operator

C1C2C1 AND C2C1 OR C2NOT C1NOT C2
TTTTFF
TFFTFT
FTFTTF
FFFFTT

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