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

25 votes161 views4 answers
Metadata
SQL
3 votes167 views3 answers
Remove all spaces from string sql
SQL
0 vote170 views1 answer
Dns slave zone convert
SQL
0 vote165 views1 answer
Mysql cdn link
SQL
0 vote165 views1 answer
Sqldf change user
SQL
0 vote306 views1 answer
Get first match in each group mysql query
SQL
4 votes176 views4 answers
Start mysql
SQL
1 vote178 views1 answer
Sql how to duplicate a table
SQL
13 votes170 views3 answers
Sql select from multiple tables without join
SQL
0 vote174 views1 answer
Case insensitive sql
SQL