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 vote294 views1 answer
Oracle free up space in tablespace
SQL
0 vote289 views1 answer
Import sql inside hide sql
SQL
0 vote373 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
5 votes285 views2 answers
Copy data from one database to another
SQL
0 vote308 views1 answer
Sql common columns
SQL
11 votes299 views1 answer
Mysql order by two columns priority
SQL
103 votes492 views2 answers
Sql server LIKE '%%'
SQL
0 vote317 views1 answer
Show tables in cassandra cql
SQL
0 vote289 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote292 views1 answer
Hw to delete a procedure in pl sql
SQL