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
剛開始接觸的時(shí)候就知道這個(gè)語法,不過當(dāng)時(shí)不知道那是個(gè)程序包調(diào)用一個(gè)存儲(chǔ)過程,現(xiàn)在想想還真是那么一回事咧
2015-04-10