一天看完了,收獲非常大,有MsSQL基礎(chǔ),再學(xué)ORACLE就方便了,主要關(guān)注下語法的不同
2016-06-10
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