12
Advanced Cursors
In Chapter 11, you explored the fundamental concepts of cursors. In this chapter, you will continue to explore cursors and learn how to pass parameters to cursors, how to take advantage of cursor variables and cursor expressions, and how to use FOR UPDATE
cursors.
Lab 12.1: Parameterized Cursors
A cursor may be declared with parameters, as shown in Listing 12.1. This approach enables a cursor to generate a specific result set that is based on the parameter values passed to the cursor at runtime.
Listing 12.1 Declaring a Cursor with Parameters ...
Get Oracle PL/SQL by Example, 6th 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.