Pl Sql Tutorial

Pl Sql Operators

OperatorFeatures
+, -, *, /, ** Arithmetic operators
AND, OR, NOTLogical operators
<, >, =, >=, <=, <>, !=Comparison operators
BETWEEN ... ANDOperator checking for belonging to a range
INOperator checking for belonging to a list of values
LIKEComparison Operator
IS NULLOperator checks whether a variable has the value NULL
||Concatenation Operator
@Remote connection Operator
&, &&Operators for addressing variables substitution
:=Assignment Operator