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 vote362 views1 answer
Postgresql interview questions
SQL
13 votes349 views2 answers
Check if value is null mysql
SQL
2 votes346 views1 answer
Oracle table size
SQL
0 vote366 views4 answers
What is unique key in sql
SQL
0 vote334 views1 answer
Oracle last connection
SQL
0 vote357 views1 answer
Postgres set default schema
SQL
1 vote384 views3 answers
Postgresql get difference between two dates
SQL
0 vote385 views1 answer
Firebase sql
SQL
0 vote366 views1 answer
Sql values not in another table
SQL
0 vote383 views1 answer
Mysql random number between 1 and 100
SQL