获取光标

在存储过程中,获取下一行光标’s result set.

句法

FETCH cursor_name INTO fetch_target [, fetch_target ]... ]

描述

This retrieves the next row of the result set into the fetch_target list. The fetch_target list is a comma separated list of variables that have been previously declared using the VAR statement.

fetch_status. 确定获取是否成功。

Nuodb SQL中的光标仅支持向前方向取样。

参数

cursor_name

The name that was associated with the cursor using DECLARE.

fetch_target

A variable that has been previously declared using the VAR statement.