UPDATE

The UPDATE statement updates the values of specified columns in rows of a table or view. Updating a row of a view updates a row of its base table. You can update one or more rows at a time, using values provided or referenced from other tables. The values that you are updating must conform to any constraints that may exist on the table or view.

You can use SQL Assist to build your INSERT statement. See SQL Assist for more information.

Examples:

Change the job (JOB) of employee number (EMPNO) '000290' in the EMPLOYEE table to 'LABORER'.

UPDATE EMPLOYEE
  SET JOB = 'LABORER' 
    WHERE EMPNO = '000290' 

Increase the project staffing (PRSTAFF) by 1.5 for all projects that department (DEPTNO) 'D21' is responsible for in the PROJECT table.

UPDATE PROJECT
  SET PRSTAFF = PRSTAFF + 1.5
  WHERE DEPTNO = 'D21'

For more information, see UPDATE in the SQL Reference topic in the Information CenterLink to Information center.