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:
Character comparisons are affected by NLS parameter settings.