Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
CREATE TRIGGER statementUse the CREATE TRIGGER statement to define a trigger on a table. You can also use CREATE TRIGGER to define an INSTEAD OF trigger on a view.
Circumstances When a Select Trigger Is Activated

Circumstances When a Select Trigger Is Activated

A query on the triggering table activates a Select trigger in these cases:

The SELECT statement is a stand-alone SELECT statement.
The SELECT statement occurs within a UDR called in a select list.
The SELECT statement is a subquery in the Projection list.
The SELECT statement is a subquery in the FROM clause.
The SELECT statement occurs within a UDR called by EXECUTE PROCEDURE or EXECUTE FUNCTION.
The SELECT statement selects data from a supertable in a table hierarchy. In this case the SELECT statement activates Select triggers for the supertable and all the subtables in the hierarchy.

For information on SELECT statements that do not activate a Select trigger, see Circumstances When a Select Trigger Is Not Activated.