Search your topic here

Oracle Cursor

Oracle Cursors:

Cursor is an important topic job interview as well as for the Oracle certificate perspective.
Cursor is a pointer in memory area called context area.
Context area is a memory region inside the Process Global Area or PGA.
Assigned to hold the information about the processing of a SELECT statement or DML Statement.

Context Area?

Context area is a memory area inside the Process Global Area(PGA) which helps Oracle server in processing an SQL statement by holding the important information about the statement.

This information include:
  1. Rows returned by a query.
  2. Number of rows processes by a query.
  3. A pointer to the parsed query in the shared pool.

Using cursor we can control the context area as it is a pointer to the same.

Types of Cursor click here.
How to create Explicit Cursor click here.