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 vote277 views1 answer
Hex string sql becomes int64
SQL
0 vote276 views1 answer
Template MySQL Zabbix agent
SQL
0 vote277 views1 answer
Get number of rows in every table mysql
SQL
0 vote289 views1 answer
Uncheck constraints and delete from table
SQL
2 votes272 views1 answer
Sql ends with string
SQL
0 vote275 views2 answers
Android sqlite query join
SQL
0 vote285 views2 answers
Advantages of stored procedures sql
SQL
9 votes296 views3 answers
Mysql run sql file
SQL
19 votes289 views6 answers
Mysql if null
SQL
0 vote271 views1 answer
SQL authentication error
SQL