What is a trigger and what are its types in Oracle?
The trigger is the procedure which is implicitly executed by the Oracle server when the INSERT, UPDATE, DELETE statement is executed against the associated table in the Oracle database.
Based on the event these are the types of trigger:-
- DDL Trigger:-INSERT/UPDATE/DELETE
- DML Trigger:-CREATE/ALTER
- DATABASE Trigger:-LOGON/LOGOFF/STARTUP/SHUTDOWN