Friday, 19 January 2018

Introduction to Cursor

In Oracle PL/SQL if we want to process multiple records then Cursors comes into pictures.
The Oracle Server uses work areas called Private SQL areas to execute SQL statements and to store processing information. Thus, we can use explicit cursors to name a private SQL area and it accesses its stored information.
Every SQL statement that is executed by the Oracle Server has an associated individual cursor. There are two types of Cursors in Oracle PL/SQL.
  1. Implicit Cursor, which is declared by PL/SQL implicitly for all DML and PL/SQL SELECT statements.
  2. Explicit Cursor, which is declared and managed by the programmer.