UPDATE emp SET sal=sal+2000 WHERE empno=erec.empno;

       END IF;

--     UPDATE emp SET sal=sal+vraise WHERE empno=erec.empno;

--       DBMS_OUTPUT.PUT_LINE(vraise);

END;

/

Q.接受两个数相除并且显示结果。如果第二个数为0，则显示消息“DIVIDE BY ZERO”。

A.

DECLARE

       num1 NUMBER;

       num2 NUMBER;

BEGIN

       num1:=#

       num2:=#

       DBMS_OUTPUT.PUT_LINE(num1 || ''''/'''' || num2 || '''' is '''' || num1/num2);

EXCEPTION

       WHEN ZERO_DIVIDE THEN

              DBMS_OUTPUT.PUT_LINE(''''Didn''''''''t your teacher tell you not to DIVIDE BY ZERO?'''');

END;

/

上一页  [1] [2] [3]