Updating using explicit cursors

by  |  10-May-2019 00:06

updating using explicit cursors-17

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.

Community Discussion