Chapter 9. Introduction to Cursors

Chapter Objectives

In this Chapter, you will learn about:

✓ Cursor Manipulation

✓ Using Cursor FOR Loops and Nesting Cursors

Cursors are memory areas that allow you to allocate an area of memory and access the information retrieved from a SQL statement. For example, you use a cursor to operate on all the rows of the STUDENT table for those students taking a particular course (having associated entries in the ENROLLMENT table). In this chapter, you will learn to declare an explicit cursor that enables a user to process many rows returned by a query and allows the user to write code that will process each row one at a time.

Get Oracle® PL/SQL® Interactive Workbook, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial