Oracle SQL Operators Where Class

Operators in The WHERE Clause

The following operators can be used in the WHERE clause:

Operator
Description
=
Equal

<>
Not equal. Note: In some versions of SQL this operator may be written as !=

>
Greater than

<
Less than

>=
Greater than or equal

<=
Less than or equal

BETWEEN
Between an inclusive range

LIKE
Search for a pattern

IN

To specify multiple possible values for a column