Fires during Execute Query and Count Query processing, after Oracle Forms constructs the SELECT statement to be issued, but before the statement is actually issued. Note that the SELECT statement can be examined in a Pre-Select trigger by reading the value of the system variable SYSTEM.LAST_QUERY .
Definition Level form or block
SELECT statements, unrestricted Built-ins
Enter Query Mode no
Use a Pre-Select trigger to prepare a query prior to execution against a non-ORACLE data source.
No effect. The current query fetched no records from the table. The table is empty, or it contains no records that meet the query's search criteria.
EXECUTE_QUERY
Open the Query
Prepare the Query