Specify Filter dialog box
Description
Specify a filter to be applied to the data retrieved from
the database. Filters do not affect retrieval. Define the filter
by entering text in the filter definition box and inserting the
operators, symbols, functions and column numbers where appropriate.
To reference the original value of a column in any expression,
use the syntax column.original, where column is
the name of the column. When you click OK, the syntax is verified.
A message displays telling you whether the expression is valid.
Options
Operators
Select an operator to paste it into the expression at the
cursor.
Functions
Select a function to paste it into the expression. The argument
is selected so that you can replace it with a column name.
Columns
Select a column to paste it into the expression at the cursor.
Verify
Click to verify the expression without saving it.
Examples
This filter accepts only rows in which the qty_ordered
is greater than or equal to 24 and the qty_used is greater
than 6:
qty_ordered >= 24
and qty_used>6
To filter out all the emp_salary rows that are greater
than or equal to the original value of the emp_salary column,
enter:
emp_salary < emp_data.original