PL/SQL Programming (IV.)--Cursors

In a PL/SQL program, cursors are often used for transactions that handle multiple rows of records.

(i) The concept of cursors

To handle SQL statements, Oracle must allocate a region called the context to process the required information, including the number of rows to be processed, a pointer to the representation of the statement being parsed, and the active set of the query.

　　A cursor is a handle or pointer to a context . with cursors, PL/SQL can control the context and what happens when the statement is processed.

PL/SQL Programming (IV.)--Cursors