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.