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

3 votes194 views1 answer
Oracle list privileges
SQL
0 vote187 views1 answer
Mysql terminal run sql file
SQL
1 vote177 views1 answer
Set autoincrement to 0
SQL
0 vote187 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
0 vote188 views1 answer
Drop-toys-table
SQL
0 vote219 views1 answer
Ceil upto 2 decimal place mysql
SQL
0 vote163 views1 answer
Materialized view redshift
SQL
0 vote221 views1 answer
Alter fedora mysql 8.0 user
SQL
-1 vote190 views2 answers
Postgresql get last 10 records
SQL
2 votes207 views1 answer
Python sql
SQL