UPDATE Statement (SAP Library

UPDATE Statement

The UPDATE statement allows updating the values of selected columns of rows of a database table.

Syntax

This graphic is explained in the accompanying text

<update statement> ::= UPDATE <table name> SET <assignment list> ( <where clause> )?.

<assignment list> ::= <assignment> ( ',' <assignment> ).

<assignment> ::= <column name> '=' <update source>.

< update source > ::= <value expression>
| <dynamic parameter specification>
| NULL.

Caution

You cannot specify string literals as values for CLOB columns. Hex literals are not supported in Open SQL.

Example

UPDATE employees SET employee_name = 'Mary Jones'
WHERE employee_id = 23

Updating Columns of a Table. The name of the employee with the employee_id 23is updated to the new value 'Mary Jones' in the database table employees.