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 vote340 views1 answer
Ms sql print more than 1 variable
SQL
0 vote313 views1 answer
Getting next sequence value jpa postgress
SQL
1 vote355 views1 answer
How to use db.execute
SQL
1 vote327 views1 answer
Sql drop with dependencies
SQL
0 vote353 views2 answers
Create row number in sql
SQL
0 vote343 views1 answer
Postgresql show owner of database
SQL
0 vote335 views1 answer
Sql character index
SQL
0 vote324 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
18 votes342 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote333 views1 answer
Less than and between in sql query
SQL