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.



Oracle PL[s]SQL by Example
Oracle PL[s]SQL by Example
ISBN: 3642256902
EAN: N/A
Year: 2003
Pages: 289

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net