oracle中case中最后需要一个else

declare
cursor c is select * from emp ;
v_b emp%rowtype;
begin
open c;
loop
fetch c into v_b;
exit when c%notfound;
case
when v_b.sal='800' then
p(v_b.ename);
else
p(v_b.ename||'liyang');--这里可以写一个return;作用是不进行操作。
end case;

end loop;
close c;
end;

 

理解：不要else会报错