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 vote112 views1 answer
Transalations from sql to Linq count and group by
SQL
5 votes119 views4 answers
Start postgres server
SQL
1 vote113 views1 answer
SQL query to get all table records count from a database
SQL
0 vote118 views1 answer
Sql mod even odd
SQL
0 vote124 views1 answer
Incorrect string value: mysql
SQL
0 vote126 views1 answer
Oracle c# multiple update sql
SQL
0 vote122 views1 answer
Import sql inside hide sql
SQL
2 votes123 views3 answers
Replace null in sql
SQL
0 vote115 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote124 views1 answer
Alter table add check constraint oracle
SQL