Simple Conditions

A simple condition compares an expression with another expression or with a single result of a subquery. Oracle supports the following simple conditions:

= Equal to
!= Not equal to
< Less than
> Greater than
<> Either less than or greater than, but not equal to
<= Less than or equal to
>= Greater than or equal to

Get Oracle in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.