Updating views in oracle
Yes you heard it right, you can write an instead-of trigger on Views only and not on tables in Oracle database.
That is the restriction that you have to comply with.
Read Here: What are Modifiable and Non Modifiable Views When does an Instead-of trigger fires – Before or After the triggering event?
For example,though the View is updatable but then also the below query for this View is not valid: . If you like Geeksfor Geeks and would like to contribute, you can also write an article using contribute.or mail your article to [email protected]
See your article appearing on the Geeksfor Geeks main page and help other Geeks.
So far we have learnt DML, DDL and System Event Triggers in Oracle Database.
Today in this tutorial we will explore the concepts of Instead-of trigger in Oracle Database. Instead-of triggers in oracle database provide a way of modifying views that cannot be modified directly through the DML statements.
Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.