IF
(countSal+pesal*1.1)<50000 THEN
UPDATE emp SET sal = sal*1.1 WHERE empno = pempno;
countEmp:=countEmp + 1;
countSal := countSal + pesal * 0.1;
ELSE dbms_output.put_line('条件不足,涨不了');
EXIT;
(countSal+pesal*1.1)<50000 THEN
UPDATE emp SET sal = sal*1.1 WHERE empno = pempno;
countEmp:=countEmp + 1;
countSal := countSal + pesal * 0.1;
ELSE dbms_output.put_line('条件不足,涨不了');
EXIT;
2016-06-03