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.