How to use cursors for updating in pl sql
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'.
This is an efficient way to return a large result set from a function.
For Example: Let's create a table 'product_check' which we can use to store messages when triggers are fired.
Let's create a BEFORE and AFTER statement and row level triggers for the product table.
For Example: The price of a product changes constantly.
It is important to maintain the history of the prices of the products.
Join our conversation (20 Comments).
Click Here To Leave Your Comment How to use cursors for updating in pl sql.
Comments: