sql - Update multiple rows using CASE WHEN - ORACLE - Stack Overflow
I have the table ACCOUNT of structure as follow: ACCOUNT_ID | ACCOUNT_STATUS| 004460721 | 2 | 042056291 | 5 | 601272065 | 3 | ... try the following update account set account_status = CASE account_id WHEN 004460721 then ......