The general format of a condition is:
[expression] [operator] [expression]
Parameters |
Description | ||||||||||||
expression |
Specifies the values that define the condition.
| ||||||||||||
operator |
Specifies a comparison operator, such as greater than (>), less than (<), and equal to (=). The most common operators are listed in the Data menu and the Icon Bar. There are also a number of special comparison operators such as BETWEEN, LIKE, and IN. There are also three logical (Boolean) operators (AND, OR, NOT) that enable you to create multiple or negative conditions. |
For more information about Oracle syntax for various datatypes, refer to the Oracle9i Server SQL Language Reference Manual.
About conditions (Query Builder)
Adding conditions to a query (Query Builder)
Copyright © 1984, 2005, Oracle. All rights reserved.