FETCH Cursor

In a stored procedure, user defined function or trigger, fetch the next row of the cursor's result set.

Syntax

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

Description

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.

Use FETCH_STATUS to determine whether the fetch was successful or not.

Cursors in NuoDB SQL only support fetching in a forward direction.

Parameters