TO_MANY_ROWS EXAMPLE

TO_MANY_ROWS:
               This exception is raised when the user trying to fetch more than one record at a time.
Exmaple:
     DECLARE
N NUMBER:=&N;
BEGIN
CASE N
WHEN 101 THEN
DBMS_OUTPUT.PUT_LINE('FIRE STATION');
WHEN 108 THEN
DBMS_OUTPUT.PUT_LINE('AMBULANCE');
WHEN 100 THEN
DBMS_OUTPUT.PUT_LINE('POLICE STATION');
END CASE;
EXCEPTION
WHEN CASE_NOT_FOUND THEN
DBMS_OUTPUT.PUT_LINE('SORRY YOU HAVE ENTERED WRONG NUMBER');
END;