--%TYPE AND NO_DATA_FOUND EXAMPLE

DECLARE
V_ENAME     EMP.ENAME%TYPE;
V_SAL            EMP.SAL%TYPE;
V_DEPTNO    EMP.DEPTNO%TYPE;

BEGIN
SELECT ENAME,SAL,DEPTNO INTO V_ENAME,V_SAL,V_DEPTNO FROM EMP WHERE EMPNO=&EMPNO;
DBMS_OUTPUT.PUT_LINE(V_ENAME||' '||V_SAL||' '||V_DEPTNO);

EXCEPTION
WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT.PUT_LINE('SORRY YOU HAVE ENTERED WRONG EMPLOYEE NUMBER PLEASE ENTER CORRECT EMPLOYEE NUMBER');
END;