Using Comparison Operators : Comparison Operators « Introduction « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Introduction
  3. Comparison Operators

There are many comparison operators that you can use in a WHERE clause:

The following table lists the comparison operators.

OperatorDescription
=Equal
<> or !=Not equal
<Less than
>Greater than
<=Less than or equal
>=Greater than or equal
ANYCompares one value with any value in a list
ALLCompares one value with all values in a list










1.3.Comparison Operators
1.3.1.Using Comparison Operators
1.3.2.Uses the not equal (<>) operator in the WHERE clause
1.3.3.Using the > operator
1.3.4.Use >= operator (2)
1.3.5.Use <= operator
1.3.6.Larger and equals
1.3.7.Less and equals
1.3.8.invalid relational operator