TRIGGERS

Prerequisites

You have generated the demo data for the SQL Tutorial.

Log on to the demo database instance DEMODB as user MONA.

Define triggers. Proceed as described in SQL Tutorial, Database Triggers.

Examples

You can use the system table TRIGGERS to determine the following database information, among other things:

?     Update trigger for the HOTEL table

SELECT triggername, definition
  FROM DOMAIN.TRIGGERS
    WHERE tablename = 'HOTEL'
      AND UPDATE = 'YES'

?     Table and action for which the trigger HOTEL_UPDATE was defined

SELECT owner, triggername, insert, update, delete
  FROM DOMAIN.TRIGGERS
    WHERE triggername = 'HOTEL_UPDATE'