Oracle PL/SQL Cursors
The information within a SQL Statement can be manipulated by means of assigning a name to a "select" statement, this concept is known as cursor. A cursor is used for processing individual rows returned as a result of a query.
A D V E R T I S E M E N T
Explicit Cursors
Explicit cursors are SELECT statements that are DECLAREd explicitly in the declaration section of the current block or in a package specification. Use OPEN, FETCH, and CLOSE in the execution or exception sections of your programs.
Implicit Cursors
Whenever a SQL statement is directly in the execution or exception section of a PL/SQL block, you are working with implicit cursors. These statements include INSERT, UPDATE, DELETE, and SELECT INTO statements. Unlike explicit cursors, implicit cursors do not need to be declared, OPENed, FETCHed, or CLOSEd.
|
