Triggers in Oracle

Triggers can be used for many things, including maintaining Complex Integrity constraints, auditing information and so many things. But every one will take a moment to tell how many types of triggers can we create on a table.

The major parts of the trigger are
Category Values Count
Statement INSERT, DELETE, UPDATE 3
Timing BEFORE or AFTER 2
Level ROW or Statement 2

So total types of trigger we can have on a table is 3*2*2 = 12.

Next Time onwords you dont have to remember anything, just follow the logic