Adding conditions to a query (Query Builder)
To add conditions to a query:
- In the Query window, click in the blank condition
field in the Conditions panel.
- In the Data Source panel, select the column (either
select the check box next to the column, or double-click the column name)
to which you want to apply a condition. To display a list of all available
columns, click
in the Icon bar to display the Paste Column
dialog box. 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. - Add the appropriate operator
(comparison, arithmetic, or logical)to your condition.
- To add functions
to your condition, click
in the Icon bar. - Type or select a column for the appropriate value
for the right side of your condition expression after the operator.
- To add another condition, press Shift-Enter to
move the cursor to a new line.
- If you’re satisfied with your expression, click
outside the condition field but within the Conditions panel to deactivate
it, or click
in the Icon bar.
Clearing the Conditions panel
- To clear the Conditions panel and start over,
click
in the Icon bar.
See also
About
conditions (Query Builder)
Condition
syntax (Query Builder)
Controlling
join conditions in linked queries (Query Builder)
Creating
a negating condition (Query Builder)
Creating
a nested condition (Query Builder)
Pasting
a function (Query Builder)
Copyright © 1984, 2005, Oracle. All rights reserved.