Filter
Top Products
[Figure: Example of updating data using a cursor (column to be updated is not in the curso
r table)]
Data can also be updated using an UPDATE statement without using a cursor. For more information on this method,
see 3.2 "Updating Data in a Data Base".
This method of updating data using an UPDATE statement is called UPDATE statement (positioned) because the row
to be updated is specified by positioning the cursor.
4.6 Deleting Data Using a Cursor
Use the DELETE statement to delete data from a row in which a cursor is positioned. An updatable cursor must be
specified in a DELETE statement. The following is an example of specifying the DELETE statement:
Example:
In this example, the row in which the cursor is positioned in Figure: Example of using a FETCH
statement to position a cursor is deleted.
55