vmesg CHAR(50);
BEGIN
SELECT job,sal INTO vjob,vsal FROM emp WHERE empno=no;
IF vjob=''''CLERK'''' THEN
IF vsal>=1500 AND vsal<=2500 THEN
vmesg:=''''Salary is OK.'''';
ELSE
vsal:=1500;
vmesg:=''''Have updated your salary to ''''||TO_CHAR(vsal);
END IF;
ELSIF vjob=''''SALESMAN'''' THEN
IF vsal>=2501 AND vsal<=3500 THEN
vsal:=2501;
ELSIF vjob=''''ANALYST'''' THEN
IF vsal>=3501 AND vsal<=4500 THEN
vsal:=3501;
IF vsal>=4501 THEN
vsal:=4501;
上一页 [1] [2] [3] [4] 下一页
Copyright @ 2007-2012 敏韬网(敏而好学,文韬武略--MinTao.Net)(学习笔记) Inc All Rights Reserved. 闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)
鄂公网安备 42011102001154号
站长:MinTao ICP备案号:鄂ICP备11006601号-18