The Column value field shows the value a column is set to in the SET clause. The value is for the column you have selected in the SET columns list.

The initial value set for each column is a host variable with the same name as the column.

Use this field to specify a new value for a column in the SET columns list. The value can be a literal, host variable, expression, or NULL.

You can use the Column value pull-down menu to specify an expression or NULL for the column value.

To apply a unary operator to the column value you have specified, from the Column value pull-down menu, select the unary operator you want to apply.

For the UPDATE statement to be valid, you must specify a value for each column in the SET clause.

The data type of the column you have selected in the SET columns list is displayed directly below the Column value field.

If there are no columns in the SET columns list or one is not selected, Column value is not available.