Specifies a predicate that SQL evaluates to generate an
intermediate result table. SQL evaluates the predicate for each
row of the intermediate result table created by the FROM clause.
The rows of that table for which the predicate is true become
another intermediate result table for later clauses in a select
expression.
Column names specified in the predicate of the WHERE clause must
either:
o Identify columns of the intermediate result table created by
the FROM clause.
o Be an outer reference (possible only if the WHERE clause is
part of a column select expression). See Outer_References for
more information on outer references.
In general, the predicate in a WHERE clause cannot refer to an
aggregate function. For instance, the following statement is
invalid:
SQL> SELECT * FROM EMPLOYEES WHERE MAX(LAST_NAME) > 'X';
%SQL-F-INVFUNREF, Invalid function reference