Declaring a cursor with parameters should include writing a program in PL/SQL that declares a cursor by
- naming the cursor
- defining the variable that can be passed
- selecting the data columns
- selecting the files
- selecting the rows.
Using a cursor with parameters should include
- using a simple loop example:
- OPEN the cursor, providing a value to the variable to be passed.
- Create a LOOP.
- FETCH the cursor.
- Manipulate, read the data.
- Close the LOOP.
- Close the cursor.
- using a FOR LOOP example
- using the parameter in a FOR LOOP program.