December 2002
Intermediate to advanced
928 pages
85h 29m
English
A cursor is essentially a pointer into a result set in the database. Cursors are used to access data in a result set on a row-by-row basis. The two types of cursors are:
SELECT statements DECLAREd explicitly in the declaration section of the current block or in a package specification
Automatically created in response to an SQL statement in the execution section of the PL/SQL block
See the discussion of using explicit and implicit cursors under the later Section 9.4 heading.