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 vote183 views1 answer
Zerar auto increment mysql
SQL
0 vote285 views1 answer
Trigger
SQL
15 votes190 views4 answers
How to get all tables in sql
SQL
1 vote216 views1 answer
Select count distinct multiple columns sql server
SQL
1 vote201 views1 answer
Spark sql concatenate string and int
SQL
13 votes283 views2 answers
Sqlite rename table
SQL
1 vote277 views1 answer
Sql select contem uma palavra
SQL
1 vote184 views1 answer
Store select query result in variable sql server
SQL
1 vote189 views1 answer
Python escape mysql
SQL
4 votes203 views2 answers
How to insert ip address in mysql using php
SQL