Lesson 4 | Using parameters with cursors |
Objective | Identify correct syntax for using parameters with cursors. |
Using Parameters with Cursors
You can specify parameters for cursors in a similar way that you define them for a procedure.
This allows you to pass parameters to a cursor when you open the cursor. Look at the following Slideshow to see how the syntax works and learn how to open a cursor that uses parameters.
Cursors With Parameters
The key reason for using parameters in a cursor is to help you write clear code. It is obvious to the casual reader of your code that you are passing variables X, Y, and Z to the cursor if the OPEN command contains those three variables as parameters.
The next lesson concludes this module.
Procedures Functions Cursors Parameters - Quiz