Creation should include the following:
- Describing the ON DATABASE clause
- Describing the ON SCHEMA clause
- Reviewing triggers for other DDL statements
- Writing the trigger:
- Trigger name—Defining the trigger name
- Timing—Determining when the trigger will execute; before, after, or instead of
- Event—Determining the database event and ON DATABASE or ON SCHEMA
- Trigger body—Writing a PL/SQL block to include the actions of the trigger