gay cell dating - Oracle if updating trigger

A trigger is a pl/sql block structure which is fired when a DML statements like Insert, Delete, Update is executed on a database table.

The below example shows how Trigger's can enter into cyclic cascading. 2) The UPDATE Trigger, trigger B on table 'xyz' issues an INSERT on table 'abc'.

In such a situation, when there is a row inserted in table 'abc', trigger A fires and will update table 'xyz'.

We can create a trigger to update the 'product_price_history' table when the price of the product is updated in the 'product' table.

1) Create the 'product' table and 'product_price_history' table Once the above update query is executed, the trigger fires and updates the 'product_price_history' table.

INSTEAD OF UPDATE triggers can be defined on a view or table to replace the standard action of the UPDATE statement.

Typically, the INSTEAD OF UPDATE trigger is defined on a view to modify data in one or more base tables.

This events will alternates between BEFORE and AFTER row level triggers.

4) Finally the AFTER statement level trigger fires.

UPDATE statements that reference views with INSTEAD OF UPDATE triggers must supply values for all nonnullable view columns referenced in the SET clause.

Tags: , ,