9.18.UPDATE Statement

Existing rows (or records) are changed in the database using the UPDATE statement.

NULL values can be utilized using the NULL keyword without any quotes. Since NULL is a special keyword you do not need to enclose it in single quotes, doing so will cause it be read as a string-literal.

The update statement is made up by selecting the table to update, the search condition that identifies which rows you want to update, and the column=value of each column you wish to change.

Example9.30.Basic Update Statement

A table can be updated using:

update demo.dba.employees e
  set username = 'thing'
  where email_address = 'thing@thingdom.com'
  ;

Example9.31.Update from Select

It is possible to update one table based on a select from another table. Ensure that the selection is properly conditioned to update.

update demo.dba.employees e
        set username = (select U_NAME from DB.DBA.SYS_USERS u where u.U_EMAIL = e.email_address)
        ;