The default WHERE Clause and default ORDER BY Clause properties specify standard SQL clauses for the default SELECT statement associated with a data block. These clauses are automatically appended to the SELECT statement that Oracle Forms constructs and issues whenever the operator or the application executes a query in the block.
Applies to block
Set Oracle Forms, programmatically
Required/Optional optional
Example
In the following example from an order tracking system, the WHERE Clause limits the retrieved records to those whose shipdate column is NULL. The ORDER BY Clause arranges the selected records from the lowest (earliest) date to the highest (latest) date.
WHERE shipdate IS NULL
ORDER BY orderdate
This WHERE Clause/ORDER BY Clause statement specifies the base conditions for record retrieval. The operator can further restrict the records retrieved by placing the form in Enter Query mode and entering ad hoc query conditions.