Updating record from cursor oracle

09 Apr
', '

For additional information on assigning values to PL/SQL variables, see "Assigning a SQL Query Result to a PL/SQL Variable".Oracle is transaction oriented; that is, Oracle uses transactions to ensure data integrity.The SELECT FOR UPDATE statement allows you to lock the records in the cursor result set.When we want to update or delete the cursor fetched row(s) from the database, we don’t have to form In the below code listing, the employees joined before the year 2000 are archived and during the cursor process, no other session is permitted to make any changes to those employees using the FOR UPDATE clause.The employee deletion from the transaction table is performed using the WHERE CURRENT OF clause as shown below.