December 2002
Intermediate to advanced
928 pages
85h 29m
English
PL/SQL declares and manages an implicit cursor whenever you execute a SQL DML statement (INSERT, UPDATE, DELETE, or MERGE) or a SELECT INTO that returns a single row from the database directly into a PL/SQL data structure. Whenever you use a SQL statement directly in the execution or exception section of a PL/SQL block, you are working with implicit cursors. Unlike explicit cursors, implicit cursors do not need to be declared, OPENed, FETCHed, or CLOSEd.
Like an explicit cursor, an implicit cursor is associated with a static SQL statement (in contrast to the dynamic statements described in the next section).