Oracle/PLSQL Topics: Cursors

A cursor is a mechanism by which you can assign a name to a "select statement" and manipulate the information within that SQL statement.

We've categorized cursors into the following topics:

Declare a Cursor

OPEN Statement

FETCH Statement

CLOSE Statement

Cursor Attributes (%FOUND, %NOTFOUND, etc)

SELECT FOR UPDATE Statement

WHERE CURRENT OF Statement

Cursor Examples:

Procedure that outputs a dynamic PLSQL cursor

Cursor within a cursor

Cursor with variable in an "IN CLAUSE"