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

Source: stackoverflow.com

Similar codes

1 vote200 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote209 views7 answers
10 random questions use python and SQL
SQL
9 votes202 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote198 views1 answer
Oracle for loop on list
SQL
0 vote255 views1 answer
Capabilities of sql select statements
SQL
0 vote234 views1 answer
Java spring boot connect to sql server
SQL
2 votes223 views3 answers
Application.properties spring boot mysql
SQL
6 votes196 views6 answers
Count mysql
SQL
1 vote203 views1 answer
Drop df constraint sql server
SQL
0 vote205 views1 answer
Sql change default collation to utf8
SQL