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

16 votes178 views5 answers
Select last row in sql
SQL
0 vote204 views1 answer
Table structure in sql
SQL
0 vote149 views1 answer
2020 new year
SQL
4 votes173 views1 answer
Describe table mysql
SQL
0 vote161 views1 answer
How to avoid duplicate records in sqlite
SQL
0 vote141 views1 answer
Drop all tables in azure sql database
SQL
9 votes144 views3 answers
Show table columns mysql command line
SQL
3 votes141 views2 answers
Postgres download
SQL
0 vote143 views1 answer
Export partttion and import in oracle
SQL
6 votes173 views2 answers
Difference between join vs union
SQL