Web Applications   «Prev 

Issue updates with where

1) Gould's row contains the performance_flag, salary and name columns.

2) The UPDATE required is sent with a WHERE clause.

3) Each of the columns, are specified in the update command to ensure that they have not changed since the transaction began.

4) This re-validates all of the existing new values from the original display.

5) If any of these values have changed since the row was initially retrieved, Oracle willl reject the transaction, not perform the update, and will return a non-zero error status.

6) The database will return with a NOT FOUND SQL code.