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 vote250 views1 answer
Sql if else in select
SQL
20 votes274 views6 answers
Creating a table in sql
SQL
0 vote270 views1 answer
How to get data from 2 database
SQL
4 votes252 views1 answer
To date oracle with time
SQL
0 vote271 views1 answer
Like date sql server not working
SQL
2 votes290 views2 answers
Postgres timestamp to datetime
SQL
1 vote547 views1 answer
Athena query timestamp greater than
SQL
13 votes295 views4 answers
What is sql
SQL
1 vote282 views1 answer
Oracle nvl2
SQL
0 vote253 views1 answer
C# datetime to sql server datetime
SQL