DECLARE V_RST VARCHAR2(100); IN_NM VARCHAR2(100); BEGIN IN_NM := 'SCOTT'; FOR I IN 1 .. 1000 LOOP BEGIN SELECT ENAME INTO V_RST FROM EMP WHERE ENAME = IN_NM; EXCEPTION WHEN OTHERS THEN NULL; END; END LOOP; IN_NM := 'TIGER'; FOR I IN 1 .. 1000 LOOP BEGIN SELECT ENAME INTO V_RST FROM EMP WHERE ENAME = IN_NM; EXCEPTION WHEN OTHERS THEN NULL; END; END LOOP; END;