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 vote333 views1 answer
Mysql workbench indent formatting
SQL
0 vote316 views1 answer
MySql count occurences more than"
SQL
13 votes328 views2 answers
Check if value is null mysql
SQL
1 vote364 views1 answer
Round one decimal place mysql
SQL
0 vote316 views1 answer
Create domain sql
SQL
11 votes348 views3 answers
Change column name sql server management studio
SQL
0 vote344 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote329 views1 answer
Mysql grant user wildcard database
SQL
3 votes344 views2 answers
Postgres show table schema
SQL
0 vote387 views1 answer
Array aggre distinct postgres
SQL