A(n) Instead Of trigger is a pl/sql block that manages in place of a dml action on a database view.
INSTEAD OF triggers describe how to perform insert, update, and delete functions against complex views. INSTEAD OF triggers permit applications to use a view as the sole interface for all SQL operations.
An after trigger runs after the connected insert, update, or delete changes are involved to the table. The WHEN condition can be used in an SQL trigger to specify a state. If the condition evaluates to true, the SQL views in the SQL trigger routine body are run.
To learn more about Instead Of trigger, refer
https://brainly.com/question/21564232
#SPJ4
