Update multiple rows using CASE WHEN - ORACLE - Stack Overflow

UPDATE ACCOUNT SET ACCOUNT_STATUS = CASE WHEN ACCOUNT_STATUS = '004460721' THEN 5 WHEN ACCOUNT_STATUS ...

stackoverflow.com