DECLARE
   v_ename       emp.ename%TYPE;
   v_character   VARCHAR2 (100);
   DATA          EXCEPTION;
   PRAGMA EXCEPTION_INIT (DATA, 100);
BEGIN
   SELECT ename
     INTO v_ename
     FROM emp
    WHERE empno = 10000;--there is no emp record with empno=10000
    IF (SQL%NOTFOUND)
   THEN
      RAISE DATA;
   END IF;
EXCEPTION
   WHEN DATA
   THEN
      DBMS_OUTPUT.put_line ('no data found exception');
END;

 EXCEPTION
   WHEN NO_DATA_FOUND
   THEN
      DBMS_OUTPUT.put_line ('no data found exception');
   END;

EXCEPTION 
     When SQL%NOTFOUND 
     THEN
DBMS_OUTPUT.PUT_LINE('YOUR COMMENT'(wat ever u want to display in the output));

END;

DECLARE
   v_ename       VARCHAR2 (10);
   v_character   VARCHAR2 (100);
   DATA          EXCEPTION;
   PRAGMA EXCEPTION_INIT (DATA, -77);
BEGIN
   SELECT dummy
     INTO v_ename
     FROM DUAL
    WHERE dummy = 'Z';                 --there is no emp record with empno=10000

   IF (SQL%NOTFOUND)
   THEN
      RAISE DATA;
   END IF;
EXCEPTION
   WHEN DATA
   THEN
      DBMS_OUTPUT.put_line ('no data found exception');
END;

SQL> DECLARE
  2     v_ename       VARCHAR2 (10);
  3     v_character   VARCHAR2 (100);
  4     DATA          EXCEPTION;
  5     PRAGMA EXCEPTION_INIT (DATA, -77);
  6  BEGIN
  7     SELECT dummy
  8       INTO v_ename
  9       FROM DUAL
 10      WHERE dummy = 'Z';                 --there is no emp record with empno=10000
 11  
 12     IF (SQL%NOTFOUND)
 13     THEN
 14        RAISE DATA;
 15     END IF;
 16  EXCEPTION
 17     WHEN DATA
 18     THEN
 19        DBMS_OUTPUT.put_line ('no data found exception');
 20  END;
 21  /
DECLARE
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 7

SQL> DECLARE
  2     v_ename       VARCHAR2 (10);
  3     v_character   VARCHAR2 (100);
  4     DATA          EXCEPTION;
  5  -- PRAGMA EXCEPTION_INIT (DATA, -77);
  6  BEGIN
  7    BEGIN
  8      SELECT dummy INTO v_ename FROM DUAL WHERE dummy = 'Z';   
  9    EXCEPTION
 10      WHEN NO_DATA_FOUND THEN RAISE DATA;
 11    END;
 12  EXCEPTION
 13     WHEN DATA
 14     THEN
 15        DBMS_OUTPUT.put_line ('no data found exception');
 16  END;
 17  /
no data found exception

PL/SQL procedure successfully completed.