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

11 votes307 views2 answers
Import mysql dump command line windows
SQL
0 vote183 views1 answer
How to install Firebird
SQL
0 vote123 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
0 vote179 views2 answers
Temp Space
SQL
0 vote212 views2 answers
How to type a blank discord messgae
SQL
0 vote170 views1 answer
Enable Rabbitmq management plugin
SQL
0 vote185 views1 answer
Psql attribute cannot login
SQL
0 vote175 views1 answer
Mysql create table like
SQL
0 vote173 views1 answer
Sql select all tables from database change url
SQL
7 votes181 views2 answers
Sql server drop temp table if exists
SQL