Oracle / PLSQL: Cursors

In Oracle, a cursor is a mechanism by which you can assign a name to a SELECT statement and manipulate the information within that SQL statement.

The following is a list of topics that explain how to use Cursors in Oracle/PLSQL:

Create Cursor

• Declare a Cursor
• OPEN Statement
• FETCH Statement
• CLOSE Statement
• Cursor Attributes (%FOUND, %NOTFOUND, etc)
• SELECT FOR UPDATE Statement
• WHERE CURRENT OF Statement

Examples

• Procedure that outputs a dynamic PLSQL cursor
• Cursor within a cursor
• Cursor with variable in an "IN CLAUSE"