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 vote143 views1 answer
Drop all procedures sql server
SQL
0 vote142 views1 answer
Codeigniter dbforge add index
SQL
0 vote197 views1 answer
SQL query to verify the size of the table
SQL
0 vote135 views1 answer
Wp_query raw sql
SQL
8 votes151 views2 answers
Sqlsrv default port
SQL
5 votes166 views1 answer
Oracle columns in all_tables
SQL
1 vote145 views1 answer
Mysql find most common value
SQL
8 votes133 views3 answers
Alter table auto_increment
SQL
0 vote132 views1 answer
Sql gather statistics to increase performance
SQL
0 vote128 views1 answer
Update if else mysql
SQL