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 vote243 views1 answer
.sql File Run in PSQL
SQL
4 votes212 views1 answer
Oracle show errors compilation
SQL
0 vote246 views1 answer
Time data type in mysql
SQL
0 vote208 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
0 vote227 views1 answer
Sql search all columns of database oracle sql
SQL
0 vote253 views1 answer
"Hello User Name"
SQL
0 vote232 views1 answer
Set classpath for mysql-connector.jar
SQL
7 votes256 views2 answers
Mysql check db size
SQL
7 votes262 views5 answers
Max 3 salary in sql
SQL
0 vote220 views1 answer
Transalations from sql to Linq count and group by
SQL