Stand-alone SELECT Statements

A Select trigger is activated if the triggering column appears in the select list of the projection clause of a stand-alone SELECT statement.

For example, if a Select trigger is defined to execute whenever column col1 of table tab1 is selected, then both of the following stand-alone SELECT statements activate the Select trigger:

SELECT * FROM tab1;
SELECT col1 FROM tab1;