The WHERE and ORDER BY block properties allow you to restrict and order the records returned to a data block by the default SELECT statement associated with that block.
You can modify the WHERE and ORDER BY clauses programmatically at runtime by executing the SET_BLOCK_PROPERTY Built-in procedure.
Remember also that operators can place the form in Enter Query mode and then further restrict the default WHERE Clause by specifying additional query conditions in data items.
You can set the default WHERE and ORDER BY clauses for a block in the Property Palette. To invoke a text editor in the Property Palette, double-click the desired property.
Tip: Select Tools | Tables/Columns to invoke the Tables/Columns browser to look up table and column names in the database.
Any valid SQL WHERE and ORDER BY clauses can be entered in the default WHERE clause and default ORDER BY clause properties. Some additional considerations are specific to Oracle Forms:
ORDER BY last_name
can be entered aslast_name
And the following is a valid WHERE clause entry:account_balance > 5000
About defining items for Enter Query mode
About defining check boxes, radio groups, and List items for querying
About executing a query programmatically
About controlling queries with Pre-Query and Post-Query triggers