Oracle SQL: the Essential Reference

UPDATE

UPDATE {[schema.]table[{@dblink] | [schema.]table PARTITION (partition) | [schema.]table SUBPARTITION (subpartition) | [schema.]table SAMPLE [BLOCK] sample_percent | [schema.]view[@dblink] | [schema.]snapshot[@dblink] } [table_alias] SET {column={expr | (subquery)}[,column={expr | (subquery)} ... | (column[,column ...])=subquery } [WHERE condition] [RETURNING expression[,expression ...] INTO data_item[,data_item ...]]

Changes the value stored in one or more columns of data in one or more tables, views, or snapshots.

Keywords

schema

The name of the schema containing the table or view that is to be updated. If omitted, the current userid is assumed.

table

Specifies the name of a table to be updated.

view

Specifies the name of a view to be updated.

snapshot

Specifies the name of a snapshot to be updated.

PARTITION

Specifies that data be updated in the partition of table identified by partition.

SUBPARTITION

Specifies that data be updated in the subpartition of table identified by subpartition.

SAMPLE

Specifies that a random sample of the rows in the table be updated. The sample size is specified by sample_percent. If the optional keyword BLOCK is specified, block sampling rather than row sampling will be performed.

subquery

Any valid SELECT statement. Note that a subquery may not contain a FOR UPDATE clause.

table_alias

Specifies an alias (or alternate name) for a table, view, or snapshot.

column

The name of a column in the table, view, or snapshot that will be updated. ...