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.
After completing this lab, you will be able to
• Use parameters in a cursor
• Use complex nested cursors
A cursor can be declared with parameters. This ...