if(saltotal+psal*1.1)<50000 then
update emp set sal=sal*1.1 where empno=pempno;
pcount:= pcount + 1;
saltotal := saltotal+psal*0.1;
else exit;
end if;
update emp set sal=sal*1.1 where empno=pempno;
pcount:= pcount + 1;
saltotal := saltotal+psal*0.1;
else exit;
end if;
2015-04-12