What Codes Are Passed in TRIG_OPER to the Trigger?

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