Standard WQL Operators for WHERE Clauses
You can use the following standard WQL operators for a binary expression in the WHERE clause of a SELECT statement.
Table 5–4 WQL Operators for WHERE Clauses|
Operator |
Description |
|---|---|
|
= |
Equal to |
|
< |
Less than |
|
> |
Greater than |
|
<= |
Less than or equal to |
|
>= |
Greater than or equal to |
|
<> |
Not equal to |
- © 2010, Oracle Corporation and/or its affiliates