We are updating a field in sql and alter
A searched update statement depends on the table being updated, all of its conglomerates (units of storage such as heaps or indexes), all of its constraints, and any other table named in the WHERE clause or SET expressions.
A CREATE or DROP INDEX statement or an ALTER TABLE statement for the target table of a prepared searched update statement invalidates the prepared searched update statement.
The positioned update statement depends on the cursor and any tables the cursor references.
You can compile a positioned update even if the cursor has not been opened yet.
Whenever you alter the value of a column referenced by the -- All the employees except the manager of -- department (WORKDEPT) 'E21' have been temporarily reassigned.
However, removing the open cursor with the JDBC method invalidates the positioned update.A CREATE or DROP INDEX statement or an ALTER TABLE statement for the target table of a prepared positioned update invalidates the prepared positioned update statement.