To delete rows in a table, a cursor can be used to verify each row's contents and delete the rows one row at a time. Figure 2-16 shows the procedure for using a cursor to delete rows in a table.

Figure 2-16 Procedure for deleting a table

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

Figure 2-17 shows an example of using a cursor to delete data one row at a time. It is assumed that the steps up to data fetching have been completed.

Figure 2-17 Example of using a cursor to delete rows