示例3 隐式游标的技巧

DECLARE 

v_deptno VARCHAR2(10);

BEGIN

SELECT deptno INTO v_deptno 

FROM emp WHERE empno=7788;

        DBMS_OUTPUT.PUT_LINE('职员部门编号为'||v_deptno);

EXCEPTION

WHEN NO_DATA_FOUND THEN

  DBMS_OUTPUT.PUT_LINE('职员未找到');

END;