FOR UPDATE Clause And Using WHERE CURRENT OF clause

FOR UPDATE Clause:

• FOR UPDATE clause explicitly locks the records stored in the private work area.
• The FOR UPDATE clause in the cursor query is used to LOCLK the affected rows while the cursor is opened.
• You need not need provide an explicit COMMIT command to release the lock acquired by using the FOR UPDATE clause.

Using WHERE CURRENT OF clause:

• WHERE CURRENT OF clause to refer the current record, fetched from the explicit cursor.
• We need to suffix the name of the explicit cursor with the CURRENT OF clause to refer to current record.
• In order to use the WHERE CURRENT OF clause, you need to lock the record fetched from the cursor.