Friday, 19 January 2018

Explicit Cursors in Oracle PL/SQL

We declare Explicit Cursors in PL/SQL when we have a SELECT statement that returns multiple row and we want to process each row returned by the SELECT statement.
The set of rows returned by the multiple-row query is called ACTIVE SET. Its size is the number of rows that meet the search criteria.
Thus Explicit Cursors:-
  1. Can perform row-by-row processing beyond the first row returned by the query.
  2. Explicit Cursor can keep track of the row that is currently being processed.
  3. Enable the programmer to manually control Explicit Cursors in PL/SQL block.