December 2002
Intermediate to advanced
928 pages
85h 29m
English
With Oracle8i, you can use cursor variables for dynamic SQL.
A cursor variable can be declared in the declaration section of the PL/SQL program as an instance of a REF CURSOR datatype. To use a CURSOR variable, you open it with a SQL statement with the OPEN. . .FOR syntax shown in the following entry. Once you have opened a cursor variable, you can use FETCH and CLOSE with the same syntax as that shown for explicit cursors.