Home >> FAQs/Tutorials >> Oracle Tutorials
Oracle Tutorials - Working with Cursors in PL/SQL
A collection of 19 FAQs on working with database objects in PL/SQL. Clear answers are provided with tutorial exercises on defining, opening, and closing cursors, looping through cursors, defining and using cursor variables.
Topics included in this FAQ are:
- What Is a Cursor?
- How Many Types of Cursors Supported in PL/SQL?
- What Is the Implicit Cursor?
- How To Use Attributes of the Implicit Cursor?
- How To Loop through Data Rows in the Implicit Curosr?
- How To Define an Explicit Cursor?
- How To Open and Close an Explicit Cursor?
- How To Retrieve Data from an Explicit Cursor?
- How To Retrieve Data from a Cursor to a RECORD?
- How To Use FETCH Statement in a Loop?
- How To Use an Explicit Cursor without OPEN Statements?
- Can Multiple Cursors Being Opened at the Same Time?
- How To Pass a Parameter to a Cursor?
- What Is a Cursor Variable?
- How To Define a Cursor Variable?
- How To Open a Cursor Variable?
- How To Loop through a Cursor Variable?
- How To Pass a Cursor Variable to a Procedure?
- Why Cursor Variables Are Easier to Use than Cursors?
Sample scripts used in this FAQ collection assumes that you are connected to the server with the HR user account
on the default database instance XE. See other FAQ collections on how to connect to the server. It is also assumed
that you are using SQL*Plus to practice the tutorial exercises.
(Continued on next topic...)