How to use cursors for updating in pl sql

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.

how to use cursors for updating in pl sql-61how to use cursors for updating in pl sql-7how to use cursors for updating in pl sql-86

Join our conversation (20 Comments).
Click Here To Leave Your Comment How to use cursors for updating in pl sql.

Comments:

Leave a Reply

Your email address will not be published. Required fields are marked *