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.
SELECT Statements Within UDRs in the Select ListA Select trigger is activated by a UDR if the UDR contains a SELECT statement within its statement block, and the UDR also appears in the Projection clause of a SELECT statement.

SELECT Statements Within UDRs in the Select List

A Select trigger is activated by a UDR if the UDR contains a SELECT statement within its statement block, and the UDR also appears in the Projection clause of a SELECT statement.

For example, assume that an enabled Select trigger is defined on the table tab1, and that a UDR named my_rtn contains this SELECT statement in its statement block:

SELECT col1 FROM tab1;

Now suppose that the following SELECT statement invokes the my_rtn UDR in its projection list:

SELECT my_rtn() FROM tab2;

This SELECT statement activates the Select trigger defined on column col1 of table tab1 when the my_rtn UDR is executed.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.