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 vote356 views1 answer
Sql alchemy escape ; in insert statement
SQL
0 vote290 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
1 vote349 views1 answer
Snowflake rename column name
SQL
9 votes371 views6 answers
Oracle substring
SQL
0 vote385 views1 answer
Sql query wordpress export post
SQL
0 vote357 views4 answers
First max salary in sql
SQL
4 votes346 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote310 views2 answers
Spring properties file for db
SQL
0 vote345 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
2 votes426 views5 answers
Tablespace ORACLE
SQL