Creating a nested condition (Query Builder)
To create a nested condition:
- In the Query window, in the Condition field, type
the first expression using a comparison operator,
such as: TOTAL<1000. Note:
When you
select a column object from a table, Query Builder automatically uses
the table alias in your query. Likewise,
if you include a column object in the Condition field and accept the condition,
Query Builder automatically inserts the appropriate table aliases into
your condition.
- Type the next expression, using another comparison
operator, such as: EMP.LAST_NAME=SMITH
- Type a third expression, using the same comparison
operator (=), such as: EMP.LAST_NAME=JONES.
- Select the second and third expressions.
- Click
in the Icon
Bar. - Click
in the Icon
Bar.
See also
About
conditions (Query Builder)
Adding
conditions to a query (Query Builder)
Condition
syntax (Query Builder)
Controlling
join conditions in linked queries (Query Builder)
Creating
a negating condition (Query Builder)
Pasting
a function (Query Builder)
Copyright © 1984, 2005, Oracle. All rights reserved.