Filter
Top Products
If this trigger is defined and an SQL statement that updates the STOCK table is executed, the update operation
specified in the triggered SQL statement is automatically executed. To define an update-and-add trigger, specify
ROW_ID in the WHERE clause in the triggered SQL statement.
Example 3: Trigger for calling a procedure routine
When a line is entered to the ORDER table, the trigger "ORDER trigger 2" calls a procedure routine
"ORDER routine." The ORDER routine checks the consistency of the entered data. Then, it changes a
stock quantity in the STOCK table according to the ordered quantity.
Sample procedure routine definition
Sample trigger definition
46