Updating using explicit cursors
A cursor holds the rows returned by the SQL statement.
The set of rows the cursor holds is referred as active set.
Explicit Cursors Programmers create explicit cursors, and with these you can do operations on a set of rows, which can be processed one by one.
You use explicit cursors when you are sure that the SQL statement will return more than one row.
Oracle creates context area for processing an SQL statement which contains all information about the statement.