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 vote119 views1 answer
Compare two tables to find unmatched records
SQL
2 votes129 views1 answer
Mysql create user with mysql_native_password
SQL
0 vote174 views1 answer
Oracle show running job
SQL
1 vote191 views2 answers
Sql server find all foreign keys that reference a column
SQL
7 votes131 views1 answer
Xampp reset mysql
SQL
1 vote119 views1 answer
Too many connections mysql
SQL
2 votes134 views1 answer
Apex execute batch job
SQL
8 votes125 views3 answers
Oracle auto_increment
SQL
0 vote120 views1 answer
Mysql select last 15 minutes
SQL
8 votes119 views2 answers
Mysql query dates between two dates
SQL