使用CASE WHEN-ORACLE更新多行

好吧，根据您给的小提琴，我尝试了这些，对我有用

create table account(  account_id number primary key,     account_status varchar2(30));insert into account values(1, '5');insert into account values(2, '3');insert into account values(3, '2');select * from accountupdate accountset account_status= casewhen account_id=1 then '2'when account_id=2 then '5'when account_id=3 then '3'ENDselect * from account

我没有使用where条件