Types of Cursors in PL/SQL
Cursors are classified depending on the circumstances in which they are opened.
- Implicit Cursor: If the Oracle engine opened a cursor for its internal processing it is known as an Implicit Cursor. It is created “automatically” for the user by Oracle when a query is executed and is simpler to code.
- Explicit Cursor: A Cursor can also be opened for processing data through a PL/SQL block, on demand. Such a user-defined cursor is known as an Explicit Cursor.
Cursors in PL/SQL
A Cursor in PL/SQL is a pointer to a context area that stores the result set of a query.