FETCH

Fetch rows from a cursor.

Synopsis

FETCH [ direction [ FROM | IN ] ] cursor_name

Where direction can be empty or one of:

NEXT RELATIVE count ABSOLUTE position count ALL FORWARD FORWARD count FORWARD ALL

Description

Fetches rows from a cursor created using DECLARE.

A cursor has a position and each time you use FETCH, the position changes and the rows spanning the position change get returned.

Parameters

direction

NEXT:

Fetch the next row. This is the default

RELATIVE count:

Fetch count rows relative to the current position.

ABSOLUTE position:

Jumps to the position and returns the row, or an empty result if jumped to a position outside the result set.

Jumping backward is only possible if the cursor was created with SCROLL set in DECLARE.

count:

Fetch the next count rows

ALL:

Fetch all remaining rows

FORWARD:

Same as NEXT

FORWARD count:

Same as count

FORWARD ALL:

Same as ALL

BACKWARD:

Move 1 row back

Moving backward is only possible if the cursor was created with SCROLL set in DECLARE.

BACKWARD count:

Move count rows back

Moving backward is only possible if the cursor was created with SCROLL set in DECLARE.

count

A integer constant, determining which or how many rows to fetch

cursor_name

Name of the cursor to fetch rows from.