Oracle PL/SQL - PL/SQL Comparison Operators


Comparison operators compare one expression to another.

The result is always either TRUE, FALSE, or NULL.

If the value of one expression is NULL, then the result of the comparison is NULL.

The comparison operators are:

  • IS [NOT] NULL Operator
  • Relational Operators
  • LIKE Operator
  • BETWEEN Operator
  • IN Operator

Character comparisons are affected by NLS parameter settings.

Related Topics