title: Insert Multiple Rows in Oracle
body: <p>Suppose we have an insert script that is consist 10000 statement like following;</p>
  
  <pre><code>Insert into CATEGORIES(CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, PICTURE)
  Values(1, 'Beverages', 'Soft drinks, coffees, teas, beers, and ales', 'beverages.gif');
  
  Insert into CATEGORIES(CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, PICTURE)
  Values(2, 'Condiments', 'Sweet and savory sauces, relishes, spreads, and seasonings', 'condiments.gif');
  </code></pre>
  
  <p>So how can I insert all the rows simultaneously? If I use ";" I can insert row by row but I don't want to insert this way. Or If I delete ";" I get error.</p>
  
  <p>Thanks in advance..</p>