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

4 votes290 views2 answers
Sql offset
SQL
0 vote288 views5 answers
Select concat alter table mysql
SQL
14 votes294 views3 answers
Inner join sql oracle
SQL
0 vote265 views1 answer
Mysql drop multiple tables at once
SQL
0 vote297 views1 answer
Openquery join two tables
SQL
0 vote287 views1 answer
How to search query in python3 sqlite3
SQL
1 vote290 views1 answer
Round function in sql oracle
SQL
0 vote267 views2 answers
How to save result of sqlite query in a table
SQL
0 vote307 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
0 vote277 views1 answer
PSQL qith variables
SQL