title: Oracle : Inserting large dataset into a table
body: <p>I need to load data from different remote database into our own database. I write a single "complex" query using WITH statement. It is around 18 Million rows of data. </p>
  
  <p>What is most efficient way to do the insert? </p>
  
  <ol>
  <li>using cursor insert one by one</li>
  <li>using INSERT INTO</li>
  </ol>
  
  <p>or is there any other way? </p>