About this document

DML Trigger Quiz and Best Practices by Catalina Achim is a document available to read on EtoBox.

Three triggers are needed to log DML operations on the EMPLOYEES and DEPARTMENTS tables. Possible timing keywords for triggers are BEFORE, INSTEAD OF, and AFTER. A trigger cannot commit and the last line should be END trigger_name. A trigger that logs updates will insert one row if an update fails due to a constraint violation. The correct syntax to trigger on updates of a specific column is CREATE TRIGGER job_upd_trigg AFTER UPDATE OF job_id ON employees.

Author

Catalina Achim

Language

EN