A Select trigger can be activated by a subquery that appears in the select list of the Projection clause of a SELECT statement.
For example, if a Select trigger was defined on col1 of tab1, the subquery in the following SELECT statement activates that trigger:
SELECT (SELECT col1 FROM tab1 WHERE col1=1), colx, col y FROM tabzEnterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]