SQL for Database Construction and Application Processing - Database Processing: Fundamentals, Design, and Implementation - page 324

update, or delete request has been processed. All together, nine trigger types are possible:
BEFORE (INSERT, UPDATE, DELETE); INSTEAD OF (INSERT, UPDATE, DELETE); and AFTER
(INSERT, UPDATE, DELETE).

Figure 7-22
result of SQL Query Using
the NameConcatenation
User-Defined Function

Figure 7-23
Summary of SQL triggers by
DBMS Product

Trigger Type BEFORE INSTEAD OF AFTER

DML Action

Oracle Database
SQL Server
MySQL

INSERT Oracle Database Oracle Database

SQL Server

MySQL

UPDATE Oracle Database Oracle Database

SQL Server

Oracle Database
SQL Server
MySQL MySQL

DELETE Oracle Database Oracle Database

SQL Server

Oracle Database
SQL Server
MySQL

MySQL