The naive approach USES a cursor to scan the table and execute a positioned update statement for each row.

初级的方法是使用一个游标对表进行扫描，并为每一行执行一个定位的更新语句。

youdao

For example, you can loop through projects and update their statuses based on the current cursor position (see Listing 5).

例如，您可以遍历项目，并基于当前游标位置更新其状态(参见清单5)。

youdao

The next step is to execute the appropriate SQL query to construct your updateable cursor, which requires using the FOR UPDATE clause as described earlier.

下一步是执行适当的SQL查询来构造可更新的游标，方法为根据先前的描述使用 FOR UPDATE子句。

youdao

Release the row locks so that other applications can SELECT, INSERT, UPDATE, and DELETE from the table (for example, use isolation level cursor stability or uncommitted read).

释放行锁，以便其他应用程序可以对表执行SELECT、INSERT、UPDATE和DELETE(例如，使用游标稳定性(curs or stability)隔离级别或未提交读(uncommitted read)隔离级别)。

youdao

Release the row locks so that other applications can SELECT, INSERT, UPDATE, and DELETE from the table (for example, use isolation level cursor stability or uncommitted read).

释放行锁，以便其他应用程序可以对表执行SELECT、INSERT、UPDATE和DELETE(例如，使用游标稳定性(curs or stability)隔离级别或未提交读(uncommitted read)隔离级别)。

youdao