Oracle Update Statement Examples

The update statement is used to update as many rows as you need in one statement. This means
you can use multiple column = value clauses in the UPDATE statement to change as many fields as you
wish in one statement. The syntax of an Update statement is:

Update table_name
    set column = value [, column = value]
[where <restrictive-condition>]

For example, to change the phone number, job role, and salary of John Marlow,
EMPLOYEE_ID 129, we can use a single UPDATE statement.

update hr.employees
set job_id = 'ST_MAN',
phone_number = '650.124.9876',
salary = salary * 1.5
where employee_id = 129;

See also: Oracle Insert Statement Examples