Building Cursor Block

Follow these steps to build a cursor block:

1. Define a cursor.
2. Open the cursor.
3. Repeatedly fetch the data to process it.
4. Close the cursor.

In the following Slide Show, the cursor block

1. selects the product name and its inventory count from the product table,
2. opens the cursor,
3. fetches records into the cursor,
4. displays the information, then
5. closes the cursor.

Now you have learned about the basic structure of a cursor block and how to build one, how to open a cursor, how to fetch the records, and how to close the cursor.
In the next lesson, we will look at the cursor FOR loop, an alternate way to write cursor blocks.

Click the Exercise link below to build a cursor block by using an evaluative simulation.
Build Cursor Block Steps