引用類型的游標(biāo)還沒(méi)講呢,。。。。is ref cursor
2016-01-05
update emp set sal=sal*(1+0.1) where empno=pempno;
total_sal:=total_sal+psal*0.1;
countemp:=countemp+1;
if total_sal>50000 then
total_sal:=total_sal-psal*0.1;
update emp set sal=sal/1.1 where empno=pempno;
countemp:=countemp-1;
end if;
total_sal:=total_sal+psal*0.1;
countemp:=countemp+1;
if total_sal>50000 then
total_sal:=total_sal-psal*0.1;
update emp set sal=sal/1.1 where empno=pempno;
countemp:=countemp-1;
end if;
2015-12-17
老師講的好好??! 就是感冒了,記得注意保暖??! 我真的挺喜歡你的課的!
totalsal:=totalsal+psal;
累計(jì)方式得到部門總工資的方法,在部門光標(biāo)里初始化,在員工光標(biāo)里累加就行,不知道對(duì)不對(duì)
累計(jì)方式得到部門總工資的方法,在部門光標(biāo)里初始化,在員工光標(biāo)里累加就行,不知道對(duì)不對(duì)
2015-12-13