Sql oracle update multiple rows

This article is tagged with: Sql oracle update multiple rows and mysql

sql oracle update multiple rows

UPDATE employee
SET staff_no =
CASE depno
WHEN 1 THEN 'ab123'
WHEN 2 THEN 'ab321'
--...
ELSE staff_no
END
WHERE depno IN ( 1, 2 ) -- list all cases here. use a subquery if you don't want to / cannot enumerate

This article is tagged with: Sql oracle update multiple rows and mysql