Welcome to the last tutorial on the “INSTEAD-OF” triggers in Oracle database. Till so far in this series we have seen how to create INSTEAD-OF INSERT trigger and INSTEAD-OF UPDATE trigger. The only trigger that is left now is the INSTEAD-OF DELETE trigger which we will cover in today’s tutorial.
Similar to other instead-of triggers which we have seen in previous tutorial, using INSTEAD-OF DELETE we can override the standard action of Delete DML on a view.
This is a very simple example of Instead-of delete trigger intended to teach you the proper way of creating an Instead-of Delete trigger. Hope you enjoyed this quick blog. Click here to share this blog on your twitter.
Also click here to watch and participate in the giveaway on my YouTube channel. Thanks & have a great day!
You can DOWNLOAD SQL script and presentation used in the Video and in this article.