Documentation Comments
Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.
RealityV15.1Online Documentation (MoTW) Revision 7
UPDATE Statement (SQL) (m691508+update.htm)
Updates rows in a table.
UPDATE table-name SET column-identifier = [expression || NULL] {,column-identifier = [expression || NULL]}... {WHERE search-condition}
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.
The user performing this statement requires SQL UPDATE privileges on the table.
UPDATE EMP SET SAL = SAL * 1.05
UPDATE EMP SET DEPTNO = 90040 WHERE EMPNO IN(8671,8782)