First page Back Continue Last page Image

Example: Statements which Trigger the Triggers

INSERT INTO invoices VALUES

(115, 34, 'ZXA-080', '2018-02-01', 14092.59, 0, 0, 3,'2018-03-01', NULL)

DELETE FROM invoices WHERE invoice_id = 115

The Following 2 Events each trigger one of the triggers we created on the last slide

As a result these entries are entered into our invoices_audit table