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 ('

Search for oracle trigger if inserting or updating:

oracle trigger if inserting or updating-75oracle trigger if inserting or updating-78

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “oracle trigger if inserting or updating”

  1. Throughout Sri Lanka’s long history, Buddhism has remained an active part of the culture. Due to the extensive conflict and war in the northern and eastern provinces, data regarding religious affiliation is variable.

  2. You don’t know what the next screen has in store; it's like spinning the cylinder of a revolver during a game of Russian roulette. Except, instead of a revolver it’s the Internet, and instead of rounds it’s people, or genitals, or talking sandwiches.