What is a cursor? What are its types?

Oracle engine uses private working area to process queries. This work area is called as cursor. The data that is stored in the cursor is called as Active Data Set.

The main types of Cursors are:
Implicit cursors (predefined cursor): - The oracle engine implicitly opens a cursor on the server to process each SQL statement. Implicit cursors are managed by the Oracle engine itself.Advertisement

Explicit Cursors (user defined cursor): - Explicit Cursors are the cursors created by the user inside a PL/SQL block. The declare section of a PL/SQL block and used within its executable Section.