UPDATE Statement

Updates rows in a table.

Syntax

UPDATE table-name SET column-identifier = [expression || NULL] {,column-identifier = [expression || NULL]}... {WHERE search-condition}

Syntax Elements

table-name =
{owner-name.}table-identifier

owner-name
The SQL user-id of the creator of the table.

table-identifier
Any user-defined name (except a Reserved Word) starting with a letter and comprising up to 49 letters, underscores and/or numbers. Letters are case sensitive.

column-identifier
Any user-defined name (except a Reserved Word) starting with a letter and comprising up to 49 letters, underscores and/or numbers. Letters are case sensitive.

expression
Refer to the topic SQL Expression.

search-condition
Refer to the topic SQL Search Condition.

Restrictions

The user performing this statement requires SQL UPDATE privileges on the table.

Examples

UPDATE EMP SET SAL = SAL * 1.05 

UPDATE EMP SET DEPTNO = 90040 WHERE EMPNO IN(8671,8782)