update cursor 更新游标
Cursor For Update 如何写游标内部更新
cursor r update 光标更新
SELECT INSERT UPDATE DELETE CURSOR 用来操纵数据库中的数据的命令如
The naive approach USES a cursor to scan the table and execute a positioned update statement for each row.
初级的方法是使用一个游标对表进行扫描,并为每一行执行一个定位的更新语句。
For example, you can loop through projects and update their statuses based on the current cursor position (see Listing 5).
例如,您可以遍历项目,并基于当前游标位置更新其状态(参见清单5)。
All of this is fine, but the real value of directly manipulating a cursor is the ability to update the database at a particular position.
上述这些游标都很有用,但是,直接操纵游标的实际价值在于在特定位置更新数据库的能力。
应用推荐