Use a 'DECLARE cursor' statement to define a cursor over the evaluation of the query.
使用'DECLARECURS OR '语句在查询的评估上定义一个游标。
Definition of the required cursor does not occur separately by executing DECLARE cursor.
不需要通过执行DECLARE CURSOR单独定义所需的游标。
Instead, the remote database is just specified in the DECLARE CURSOR statement using the database option.
只需使用DATABASE选项在DECLARE cursor语句中指定远程数据库。
Unlike elapsed time, in case of a declare cursor statement the CPU time is the sum of open, all fetched and close.
与消耗时间不同,对于声明游标的语句,CPU时间是打开游标、所有读取操作和关闭游标的时间总和。
With the DECLARE cursor command, a cursor is defined that reads all data of the source table SALES using a trivial SELECT statement.
使用DECLARE CURSOR命令定义一个游标,它使用select语句读取源表sales的所有数据。
This also explains the use of the PREPARE, DECLARE, OPEN and CLOSE SQL cursor statements.
这也解释了使用PREPARE、DECLARE、OPEN和CLOSEsql游标语句的原因。
Declare the cursor using the WITH RETURN clause.
使用WITHreturn子句声明游标。
Declare the cursor using the WITH RETURN clause.
使用WITHreturn子句声明游标。
应用推荐