title: Reference Entire Table with Cursor then Insert based on conditions
body: <p>If I am referencing an entire table with a cursor.  Can I use the insert statement based on conditions in other tables multiple times?  For example:</p>
  
  <pre><code>V_Name                 Emp.Name%type;
  V_E_Number             Emp.Number%type;
  V_Location             Emp.Location%type;
  V_City                 Emp.City%type;
  V_P_ID                 Emp.P_ID%type;
  V_State_Code           Emp.State_Code%type;
  
  Cursor C1 is Select emp.name, emp.number, emp.Location, emp.City, emp.P_ID, emp.State_Code
               From Employee Emp, Former_Employee Femp
               Where Emp.Number = Femp.Number
               And State_Code = '4';
  
  Begin
  
  Open C1;
  
  Loop
  
  Fetch C1 Into V_Name, V_E_Number, V_Location, V_City, V_P_ID, V_State_Code;
  
  EXIT WHEN C1%NOTFOUND;
  
  IF New_Emp.P_ID != V_P_ID 
  Then Insert Into New_Emp
  Values (V_Name, V_E_Number, V_Location, V_City, V_P_ID, V_State_Code); 
  
  IF New_Emp.P_ID = V_P_ID,
     New_Emp.State_Code = V_State_Code
  Then Insert Into Emp_Archive
  VALUES (V_Name, V_E_Number, V_Location, V_City, V_P_ID, V_State_Code);  
  
  Else Do Nothing;
  
  End If;
  
  End Loop;
  
  Close C1;
  
  End;
  / 
  </code></pre>
  
  <p>Then Can I open the cursor again and use another If Statement to populate a different table with different conditions?</p>