December 2002
Intermediate to advanced
928 pages
85h 29m
English
A cursor is a pointer into a result set in the database. An explicit cursor is a cursor that you name and manipulate explicitly in your program. An explicit cursor is static; the SQL statement is determined at compile time. Static cursors are used only for DML statements (SELECT, INSERT, UPDATE, DELETE, MERGE, or SELECT FOR UPDATE).
Use the following syntax when working with explicit cursors.