Cursors (PL/SQL)

A cursor is a named control structure used by an application program to point to and select a row of data from a result set. Instead of executing a query all at once, you can use a cursor to read and process the query result set one row at a time.

A cursor in a PL/SQL context is treated as a WITH HOLD cursor. For more information about WITH HOLD cursors, see DECLARE CURSOR statement.

The Db2® data server supports both PL/SQL static cursors and cursor variables.