What is purpose and order of firing the following triggers
- on fetch
- on select

First on-select then on-fetch trigger is fired . 
On-select is used to open and execute database query. on-fetch can be used in conjunction with on-select to replace the processing that normally occur in execute query built in procedure

  1 User has rated as useful.

  

Login to rate this answer.

1)On select fires first.

On select fFires when Forms Developer would normally execute the open cursor, parse, and execute phases of a query, to identify

2)On fetch fires next

When a query is first opened, on-fetch fires immediately after the On-Select trigger fires, when the first records are fetched into the block. While the query remains open, fires again each time a set of rows must be fetched into the block.

Fires when Form Builder would normally execute the open cursor, parse, and execute phases of a query, to identify the records in the database that match the current query criteria.

FORM AND BLOCK LEVEL

EXAMPLE
IF Get_Application_Property(DATASOURCE) = 'DB2' THEN
  User_Exit ( 'Query' );
  IF Form_Failure OR Form_Fatal THEN
    ABORT_QUERY;
  END IF;
ELSE
  /*
  **  Perform the default Form Builder task of opening the query.
  */
  Select_Records;
END IF;