Title: Declare and use cursors with parameters.
Course: Database Design and Management with PL/SQL (Oracle) (10053) > Section: Using Cursors

Declaration and use should include

- defining the use of a parameter in a cursor in PL/SQL
- correlating or translating business needs into the use parameters in cursors.

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.