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 votes222 views3 answers
Mysql get column names from table
SQL
2 votes358 views1 answer
Set auto increment from 1
SQL
-1 vote201 views3 answers
Psql get last rows
SQL
0 vote193 views1 answer
How to generate ids in sql
SQL
0 vote255 views1 answer
Select * where id = 1,2,3
SQL
-1 vote205 views1 answer
Default username and password for oracle 11g
SQL
0 vote204 views1 answer
Sql examples from framework
SQL
1 vote193 views1 answer
Create temporal table in sql
SQL
0 vote232 views1 answer
Sql query tags
SQL
0 vote195 views1 answer
My sql data file extention
SQL