Multiple retrieved rows are updated by using a cursor to extract one row at a time. Figure 2-11 shows how to use the cursor to update a table.

Figure 2-11 Procedure for updating a table

The steps of the processing procedure shown in Figure 2-11 are basically the same as the steps in Figure 2-6, except for data updating.

Figure 2-12 shows an example of using the cursor to update a table. It is assumed that the steps up to data fetching have been completed.

Figure 2-12 Example of using cursor to update a table