PL/SQL Operator


Prev Tutorial Next Tutorial

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)
+Additiona+b=11
-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

BetweenNot betweenIn
Not inLikeExists
Not existsIs nullIs not null
AnyAllSome
UnionUnion allIntersect
minus

Prev Tutorial Next Tutorial

Advertisements




Facebook Likes

Advertisements