title: Insert into select query with cursor value
body: <p>I want to write a SQK script with insert query in Oracle where one of the value will be fetched from cursor and rest all will be retrieved from table. </p>
  
  <p>For example, consider Employee table:</p>
  
  <pre><code>Emp_No | Emp_Name
  
    1    |  AAA
    ...........
  </code></pre>
  
  <p>I am reading the table into a cursor.</p>
  
  <pre><code>Cursor c1 is select emp_no, emp_name from employee;
  </code></pre>
  
  <p>I am iterating the cursor and adding to a table along with information from another table.</p>
  
  <pre><code>for empCur in c1
  loop
  
  insert into employee_info(emp_no, emp_name, address, age, ... ) values (empCur.emp_no, empCur.emp_name, select t.address, t.age, ... from employee_temp_table t where t.emp_no=empCur.emp_no)
  
  end loop;
  </code></pre>
  
  <p>Is my script valid? If not is there any other way to achieve it? Since few values are in cursor and few are in another table I am not sure how to handle this.</p>