Cursor Management

Cursor Management:

• In order to process a SQL statements, Oracle will allocate an area of memory know as the context area.
• PL/SQL uses this context area to store and to execute the SQL statements.
• The information(rows) retrieved from database table, which is available in context area, is known ‘Active Set’.
• A Cursor is a pointer, which works on active set i.e., which points one row at a time in the context area.
• A cursor is used to process multiple rows using PL/SQL.