O'Reilly logo

Oracle by Elena Silvestrova Rakhimov, 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 12 Advanced Cursors

Chapter Objectives

In this chapter, you will learn about

• Using parameters with cursors and complex nested cursors

• FOR UPDATE and WHERE CURRENT cursors

In the preceding chapter you mastered basic cursor concepts. In this chapter you will learn how to dynamically alter a cursor’s WHERE clause by passing parameters when you call the cursor. Chapter 21 takes cursors to another level. In the context of a package you will also learn to implement cursor variables.

Lab 12.1 Using Parameters with Cursors and Complex Nested Cursors

Lab Objectives

After completing this lab, you will be able to

• Use parameters in a cursor

• Use complex nested cursors

Cursors With Parameters

A cursor can be declared with parameters. This ...

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