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 vote193 views1 answer
How to count with except in psql
SQL
0 vote195 views1 answer
Luu ckeditor vao mysql
SQL
0 vote197 views1 answer
Sql select duplicates based on two columns
SQL
5 votes225 views1 answer
Oracle drop index if exists
SQL
1 vote194 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
0 vote230 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
0 vote202 views1 answer
Alter table add foreign key mariadb example
SQL
0 vote208 views1 answer
Sql trigger to call stored procedure with parameters
SQL
2 votes200 views1 answer
Oracle sql concatenate results into string
SQL
0 vote201 views1 answer
Merge clause with inner join
SQL