When a trigger function is invoked it can access field TRIG_OPER to determine what operation was in progress when it was invoked.
The values passed in TRIG_OPER are:
Operation In Progress | Value In TRIG_OPER |
|---|---|
Before Open | BEFOPN |
After Open | AFTOPN |
Before Close | BEFCLS |
After Close | AFTCLS |
Before Read | BEFRED |
After Read | AFTRED |
Before Insert | BEFINS |
After Insert | AFTINS |
Before Update | BEFUPD |
After Update | AFTUPD |
Before Delete | BEFDLT |
After Delete | AFTDLT |