title: Using for loop i want to copy data from one table to another table in pl/sql code is under below
body: <p>this code is not working for me and message me and send a message </p>
  
  <pre><code>ORA-01422       exact fetch returns more than requested number of rows  
  </code></pre>
  
  <p>The code:</p>
  
  <pre><code>declare  
    a_id employees.employee_id%type;  
    b_name employees.first_name%type;  
    c_salary employees.salary%type;  
  begin  
    for i in 1..10 loop  
      select employee_id, first_name, salary into a_id, b_name, c_salary from employees 
      where employee_id='a_id', first_name='b_name', salary='c_salary';  
  
      insert into awais(employee_id, first_name, salary) values (a_id, b_name, c_salary);  
    end loop;  
  end;  
  /
  </code></pre>