Database Reference
In-Depth Information
4
/
Hello Everybody
PL/SQL procedure successfully completed.
8.6 Common Operators
An operator is a symbol or keyword that the language provides to perform an arithmetic,
logical, or other function . Following table shows common PL/SQL operators
Operator
Category
Assignment Arithmetic
Logical
Comparison (of non-nulls)
Comparison (of nulls)
String
Notation Meaning Example
:=
+
-
*
/
**
AND
OR
NOT
=
!=
<
>
<=
>=
IN
BETWEEN
IS NULL
IS NOT NULL
LIKE
Store the value
