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 votes157 views2 answers
Truncate oracle
SQL
0 vote201 views2 answers
Clauses in mysql
SQL
0 vote229 views1 answer
Sql declare variable single line
SQL
1 vote169 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
12 votes160 views3 answers
Duplicate a column in sql
SQL
1 vote172 views1 answer
Sql order by where condition
SQL
5 votes186 views2 answers
Oracle list columns
SQL
1 vote167 views1 answer
Md5 encryption for existing records
SQL
1 vote216 views1 answer
Top 10 rows in mysql
SQL
2 votes175 views1 answer
Apex execute batch job
SQL