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 votes262 views5 answers
Uninstall mysql ubuntu
SQL
0 vote247 views1 answer
Mysql workbench not showing schemas
SQL
0 vote273 views1 answer
Postgresql delete limit
SQL
1 vote239 views2 answers
Mysql update table from another table
SQL
0 vote253 views1 answer
Rabbitmq ui not working
SQL
-2 votes253 views2 answers
Sqlserver docker
SQL
7 votes278 views3 answers
Postgresql dump and restore db
SQL
0 vote279 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
0 vote240 views1 answer
Mysql with
SQL
3 votes285 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL