FETCH

Syntax

FETCH cursor_name INTO var_name [, var_name] ...

Description

This statement fetches the next row (if a row exists) using the specified open cursor, and advances the cursor pointer.

var_name can be a local variable, but not a user-defined variable.

If no more rows are available, a No Data condition occurs withSQLSTATE value 02000. To detect this condition, you can set up a handler for it (or for a NOT FOUND condition).

See Cursor Overview for an example.

See Also

• Cursor Overview

• DECLARE CURSOR

• OPEN cursor_name

• CLOSE cursor_name

• Cursors in Oracle mode

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}