O'Reilly logo

Oracle® PL/SQL® Interactive Workbook, Second Edition by Elena Silvestrova, Benjamin Rosenzweig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 15. Advanced Cursors

Chapter Objectives

In this Chapter, you will learn about:

Using Parameters with Cursors and FOR UPDATE Cursors

Cursor Variables

In the previous chapter you mastered the basic concepts of cursors. In this chapter you will learn how to dynamically alter the WHERE clause of a cursor by passing parameters to when you call the cursor. You will also learn about cursor variables. Cursor variables are like C pointers; they hold the address or memory location of an object of some type. Cursor variables are very useful for passing query result sets between PL/SQL stored subprograms and various clients. Neither PL/SQL nor any of its clients owns a result set. They simply share a pointer to the query work area that identifies ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required