What are INSTEAD OF triggers? | PLSQL Interview Questions

The INSTEAD OF triggers are used in association with views. The standard table-based triggers cannot be used by views.
These triggers inform the database of what actions are to be performed instead of the actions that invoked the trigger.
Therefore, the INSTEAD OF triggers can be used to update the underlying tables, which are part of the views.
They can be used on both relational views and object views. The INSTEAD OF triggers can only be defined as row-level triggers and not as statement-level triggers.

0 comments: