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.


Related topics

Please use contact page in this website if you find anything incorrect or you want to share more information about the topic discussed above.