使用 if(条件) then
语句;
elsif(语句) then
语句;
else
语句;
end if;
declare
v_sal emp.sal%type;
begin
select sal into v_sal from emp where empno ='7900';
if(v_sal<1300) then
update emp set sal = sal +500 where empno ='7900';
commit;
elsif(v_sal<2300) then
update emp set sal = sal +300 where empno ='7900';
commit;
else
update emp set sal = sal +100 where empno ='7900';
commit;
end if;
end;