DML Trigger

Trigger for Auditing Purposes

:NEW and :OLD are called as sudo records
They allow to access an recently changed value or accessed an recently updated or deleted value

DDL Triggers

Database Event Trigger

LOGOFF can be used to try when the user exited the Schema
DB level trigger can be created by using DATABASE and making the trigger using SYSTEM/SYS user

Require to be an SYS/SYSTEM user or have Admin system Trigger privilege

Instead of Triggers

Can be only used on Views
Can used to make non updatable views updatable