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 Statement Examples
Reviewed by J. Mathew on
Mar 18
Rating:
4.5
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
Rating:
4.5