title: how to insert large number of rows in oracle?
body: <p>Can anyone tell me how to insert large number of rows in Oracle ?</p>
  
  <p>Using insert statement we can insert data into rows of table.</p>
  
  <pre><code>            insert into example values(1,'name','address');
  </code></pre>
  
  <p>Suppose I want to insert 100,000 rows , do I need to insert one by one by following above procedure?  Or is there  any other way to insert a large number of rows at a time? Can any one advise me with an example  please.</p>
  
  <p>Note: here i'm not asking copying data from another table.. just consider we have an XL sheet consist of 1,00,000 rows,then how we can insert them into a particular table..</p>
  
  <p>Thanks,
   Sai.</p>