Oracle trigger if inserting or updating
If the after statement trigger was responsible for anything important, like cleaning up the contents of the collection, we are in trouble.
So once again, make sure you understand how the timing points are triggered, or you could get unexpected behavior.
To demonstrate this we will force an exception in the after row trigger.')'; WHEN UPDATING THEN trigger_test_api.g_tab(trigger_test_api.g_tab.last) := 'BEFORE EACH ROW - UPDATE (new.id='