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

0 vote97 views1 answer
Select top 3 sql
SQL
0 vote108 views1 answer
Sql list dates between two dates
SQL
4 votes115 views1 answer
Describe table mysql
SQL
1 vote129 views1 answer
Sql and
SQL
0 vote101 views1 answer
Sql gather statistics to increase performance
SQL
0 vote109 views1 answer
Sql column contains special character
SQL
6 votes134 views3 answers
Rename column ORACLE
SQL
-1 vote112 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote104 views1 answer
Azure sql server check foreign key
SQL
1 vote105 views1 answer
Update foreign key value in mysql
SQL