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

8 votes139 views1 answer
Oracle all_source package body
SQL
3 votes181 views2 answers
Oracle sql first day of month
SQL
1 vote145 views1 answer
Sql select whole row max column
SQL
3 votes137 views1 answer
Sql print all names that start with a given letter
SQL
1 vote130 views1 answer
Sql myisam vs innodb
SQL
0 vote148 views1 answer
Sqlalchemy get schema from database
SQL
2 votes131 views1 answer
Plsql block
SQL
0 vote136 views1 answer
Get foreign table names mysql
SQL
2 votes128 views1 answer
Get first 2 letter in sql
SQL
0 vote159 views4 answers
Rownum in sql
SQL