在游标定位在行中时,锁定这个被应用程序的某个事务访问的任何一行。
Locks any row accessed by a transaction of an application while the cursor is positioned on the row.
在本例中更适合使用逐字插入,因为这里的目标是精确地复制游标上方的文本。
Verbatim insertion is more appropriate in this example, since the aim is to exactly copy the text above the cursor.
默认情况下使用只能前进的游标。
最后,完成时,关闭游标释放资源。
Finally, when you're finished, close the cursor to free up resources.
不支持Sybase游标参数。
这意味着数据库服务器已用尽动态游标。
This means the database server has run out of dynamic cursors.
本地游标引用无明确释放。
应用程序1再次打开游标。
XML游标定义了XML文档中的一个位置。
打开将被返回的游标。
游标模型考虑了不对称和大型结果集的情况。
The cursor model takes into account the cases of asymmetry and large result sets.
使用WITHreturn子句声明游标。
当您移动游标时,是将它移动到符合要求的标志。
When you move a cursor, it moves to the token that fits the description.
以前,这类提取需要游标循环访问字符串的各部分。
Previously this kind of extraction would require cursors iterating over sections of a string.
DataPointer用于作为数据集中的游标。
清单4是一个简单的例子,说明了XML游标的用法。
因此,该字段比其他字段更能显示游标成本。
So it is a much better indicator, along with other fields, of the cost of a cursor.
此外,现在还支持新的布尔、游标、行和数组数据类型。
In addition, new Boolean, cursor, row, and array data types are now supported.
注意,要使用滚动不敏感型游标,必须关闭自动提交功能。
Note that autocommit must be off to use a scroll-insensitive cursor.
而在性能方面,只能前进的游标优于可滚动游标。
In terms of performance, the forward-only cursor is better than the scrollable cursor.
为此,您可以创建滚动不敏感型游标,如 清单4 所示。
To do that, you can create a scroll-insensitive cursor, as seen in Listing 4.
对于只读游标,使用FORREADONLY子句确保游标无歧义。
FOR read-only cursors, make the cursor unambiguous by using the FOR read only clause.
对于每个将要返回的结果集,使用WITHreturn子句声明游标。
Declare cursors for each of the result sets to be returned that specify the WITH return clause.
但某些情况下,您需要游标既能向前又能向后,此时需要使用可滚动游标。
However, in some cases, you will need to read cursors both forward and backward, in which case you should use scrollable cursor.
另外,对于T2zos,新的属性可用于单进游标和可滚动游标。
In addition, the new property is used for both forward only and scrollable cursors for T2zos.
游标的最简单类型是流水型(firehose)或仅向前型游标。
The simplest type of cursor is the firehose, or forward-only cursor.
不需要通过执行DECLARECURSOR单独定义所需的游标。
Definition of the required cursor does not occur separately by executing DECLARE cursor.
使用PDO::ATTR_CURSOR属性将游标设置为可滚动游标
Set the cursor to be a scrollable cursor using the PDO::ATTR_CURSOR attribute
两类游标都将启用滚动,滚动将使您可以在游标内相对和绝对地向前移动和向后移动。
The two cursors both enable scrolling, which lets you move around within a cursor — forward and reverse, in both a relative and an absolute sense.
注意,对于游标声明,该值为打开游标的次数,不包括该游标取数据的次数。
Note that in case of a cursor declaration the value is the number of times the cursor was opened. It does not include the number of fetches made by the cursor.
应用推荐