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

17 votes314 views4 answers
Show all tables in oracle
SQL
6 votes172 views2 answers
Mysql version check cmd
SQL
0 vote187 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote177 views1 answer
How to delete data from sql database in android
SQL
0 vote233 views1 answer
Joomla execute raw sql
SQL
2 votes184 views1 answer
Mysql virtual column
SQL
0 vote187 views1 answer
See Foreign Key
SQL
0 vote182 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote190 views1 answer
Nueva tabla mysql
SQL
0 vote199 views1 answer
Mysql select inside sum
SQL