Oracle cursor for updating every row in same table


Oracle9i allows us to use Record structures during bulk operations so long as we don't reference individual columns of the collection.

This temporary work area is used to store the data retrieved from the database, and manipulate this data.

A cursor can hold more than one row, but can process only one row at a time.

WHERE CURRENT OF & FOR UPDATE The WHERE CURRENT OF clause is used in some UPDATE and DELETE statements.

The WHERE CURRENT OF clause in an UPDATE or DELETE statement states that the most recent row fetched from the table should be updated or deleted.

It’s not enough that your code is readable: it must perform well too. Skipping or changing any of these is likely to have a negative impact on your code’s performance. But when you get implicit conversions, or you have to put in explicit conversions, you’re performing a function on your columns. But here’s the execution plan: This query ran fast enough, and the table is small, so there were only 4 reads to scan the entire thing.