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

1 vote180 views1 answer
Select not matching data from two tables
SQL
0 vote174 views1 answer
Sql find record cannot cast date
SQL
0 vote186 views1 answer
Jenkins SQLCMD run
SQL
0 vote180 views1 answer
Alter table fulltext
SQL
6 votes233 views2 answers
Oracle undotbs usage
SQL
0 vote172 views1 answer
Recursive query herarchical data sql server
SQL
10 votes182 views1 answer
Oracle object dependencies
SQL
1 vote164 views1 answer
Minus vs intersect in sql
SQL
1 vote193 views1 answer
Flask sqlalchemy default value
SQL
0 vote180 views1 answer
Sql select most frequent value in column
SQL