Collection subqueries in the projection list of a query

A Select trigger executes when the triggering column appears in a collection subquery that occurs in the projection list of another SELECT statement. The following statement executes a triggered action on the hits_trig trigger for each instance of a row that the collection subquery returns:

SELECT MULTISET(SELECT col_a FROM tab_a) FROM ...