--正確寫法
--循環(huán)1+100的和
declare
pnum number :=1;
con number := 0;
begin
while pnum <=100 loop
con := con + pnum;
--變量自增
pnum := pnum +1;
end loop;
dbms_output.put_line(con);
end;
/
-- loop開始
--exit when saltotal > 50000;
fetch cemp into cempno,csal;
exit when cemp%notfound;
if (saltotal + csal * 0.1)<50000 then
saltotal := saltotal + csal*0.1;
update emp set sal = sal * 1.1 where empno = cempno;
count1 := count1 + 1;
else exit;
end if;
