1. Home
  2. Docs
  3. Oracle 19c PL/SQL
  4. Cursors in PL/SQL
  5. Cursors Overview

Cursors Overview

A cursor is a pointer to a private SQL area that stores information about processing a specific SELECT or DML statement.

Oracle PL/SQL provides 2 types of cursors.

  • Implicit cursor : A cursor that is constructed and managed by PL/SQL is an implicit cursor. PL/SQL opens an implicit cursor every time you run a SELECT or DML statement within a PL/SQL block.
  • Explicit cursor : A cursor that you construct and manage is an explicit cursor. You must declare and define an explicit cursor, giving it a name and associating it with a query.
Was this article helpful to you? Yes No

How can we help?