Updating cursor
28-Apr-2020 10:11
Two cursor updates not separated by a fetch causes the same row to be updated twice if the cursor was opened in the direct update mode.
When executing a cursor update dynamically, using the PREPARE statement, the cursor must be open before the cursor UPDATE statement can be prepared.But if you look closely, most of the time we use cursors to iterate through a row collection and update the same table.