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 vote370 views1 answer
View t-sql mail configuration
SQL
3 votes413 views1 answer
Oracle sql commit example
SQL
1 vote396 views1 answer
Last 24 HOUR data in mysql
SQL
13 votes379 views2 answers
Get date from now() mysql
SQL
2 votes328 views1 answer
Username sql
SQL
4 votes381 views1 answer
List tables sqlite
SQL
-1 vote341 views3 answers
Update mongodb version ubuntu
SQL
0 vote366 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote514 views1 answer
ORA-01400
SQL
1 vote368 views1 answer
Print year of a date sql
SQL