5. OPERATORS
•Unary and Binary Operators
•Arithmetic Operators
•Logical Operators
•Relational Operators
•Comparison Operators
•Set Operators
•Relation Negation Operators
•Concatenation Operator
•Hierarchical Query Operators
•Multiset Operators
•User-Defined Operators
•Some other Built-In Operators
Unary : Where is one operator and one operand. Ex. a++, b--
Binary : Where is one operator and two operands. Ex a+b, a-b
Arithmetic : * , / , + , –
Logical : AND, OR, NOT
Relational / Comparison / Concatenation : <,>,<=,>=,!=,,^=,<>,||, BETWEEN, IN,NOT IN, IS NULL, IS NOT NULL,ANY/ SOME,ALL,EXISTS, NOT EXISTS
Set : Union, Union All, Intersect and intersect all, Minus
