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

-1 vote121 views1 answer
Window functions in sql
SQL
0 vote117 views1 answer
Inserted row count tsql
SQL
0 vote117 views1 answer
Can we rollback in sql
SQL
12 votes110 views4 answers
Mysql get date difference in hours
SQL
1 vote118 views1 answer
Access the postgres psql
SQL
-1 vote125 views1 answer
Concat two columns in sql server
SQL
0 vote130 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote118 views1 answer
Compare subqueries oracle
SQL
0 vote112 views1 answer
Json_remove mysql
SQL
1 vote128 views5 answers
What is in operator in sql
SQL