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 vote123 views1 answer
Xamarin sql lite create table if not exist
SQL
4 votes101 views3 answers
Oracle sql first day of quarter
SQL
0 vote100 views1 answer
Sqldf change user
SQL
0 vote99 views2 answers
Add new column after in sql
SQL
5 votes119 views4 answers
Change auto increment mysql
SQL
0 vote101 views1 answer
Sql common columns
SQL
0 vote153 views1 answer
Postgres list all stored procedures query
SQL
0 vote122 views1 answer
How to add mysql to path on termin after installation
SQL
0 vote138 views1 answer
How to change the field size of an existing column
SQL
0 vote115 views1 answer
Select row from mysql where date more than 30 days
SQL