title: PL/SQL cannot loop select statement for missing values
body: <p>In <code>HR Schema</code>, I'm writing a PL/SQL block to fetch and display all employees having <code>employee_id</code> from 150 to 200.</p>
  
  <pre><code>declare
       v_c    number(3) := 150 ;
       v_fn   varchar2(150);
  begin
       for i in  v_c .. v_c + 50
       loop
       select first_name into v_fn from employees where employee_id = i;
       dbms_output.put_line(i || ' ' || v_fn);
       end loop;    
  end;
  </code></pre>
  
  <p>However it works fine if there is data for all <code>employee_id</code> from 150 to 200.</p>
  
  <p>Suppose I am missing data for <code>employee_id = 160</code> then this is the output.</p>
  
  <pre><code>Error report -
  ORA-01403: no data found
  ORA-06512: at line 7
  01403. 00000 -  "no data found"
  *Cause:    No data was found from the objects.
  *Action:   There was no data from the objects which may be due to end of fetch.
  150 Peter
  151 David
  152 Peter
  153 Christopher
  154 Nanette
  155 Oliver
  156 Janette
  157 Patrick
  158 Allan
  159 Lindsey
  </code></pre>
  
  <p>How do I skip 160's error and display the other employees till <code>employee_id = 200</code>?</p>
  
  <p>When the select query fails, The execution of the loop must continue.</p>
  
  <p><strong>Note:</strong> I hopelessly tried to use a GOTO in EXCEPTION.</p>