What is a cursor in PL/SQL?

Cursor:

Cursor is a memory variable, it take space with in row and column.it also can take matrix data.

Also ,A cursor is a pointer that points to a result of a query.

PL/SQL has two types of cursors:

•Implicit cursors

•Explicit cursors

Implicit Cursors

Whenever Oracle executes an SQL statement such as Select Into , Insert , Update  and Delete it automatically creates an implicit cursor.

Implicit Cursors Example:

Explicit cursors

An explicit cursor is an Select statement declared explicitly in the declaration section of the current block or a package specification.

Explicit cursors Example:

Cursor with parameters:

Example:

PLSQL Records and Cursor:

Difference between records and cursor is : Cursor take data from direct table where records take data from cursor.

Cursor FOR Loops:

Example: