RelationalDBDesignRelationalDBDesign 


Web Applications   «Prev 

Issue updates with where

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

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

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

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

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.
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.

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