If a group of rows can be described by a formula, then a single request can be used to update them all. The following request, for example, updates the salaries of all employees in department 600 of the database Workforce:
update workforce.employee set salary=salary*1.07 where deptno=600;