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 vote132 views1 answer
Mysql DDL
SQL
1 vote138 views1 answer
Sql find column name like
SQL
1 vote115 views1 answer
Foreign key constraint in ms sql
SQL
0 vote130 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
6 votes133 views2 answers
Join vs union
SQL
2 votes115 views2 answers
How to get capital letter first in sql
SQL
0 vote123 views1 answer
Netstat -tln mysql
SQL
4 votes134 views2 answers
Postgre sql create table
SQL
1 vote163 views1 answer
Show databases mysql docker
SQL
0 vote138 views1 answer
Mysqldump don't drop table
SQL