Home » SQL » Oracle Update Statement Examples

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

Update Statement Examples

Reviewed by J. Mathew on

Mar 18