Fetching Records from the cursor:

FETCH statement loads the row addressed through the cursor pointer into variables and moves the cursor pointer on to the next row ready for the next fetch. After each fetch, the cursor pointer will moves to the next row in the result set.

Syntax

FETCH <cursor name> INTO <variable list>

Example

FETCH C1 INTO x,y;

Here assume the variables x and y are already described. For every column which is used in the SELECT list a corresponding variable in the INTO list must appear. Or else it leads to an error.