title: How can I insert multiple row into oracle database using one insert statement?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/39576/best-way-to-do-multi-row-insert-in-oracle">Best way to do multi-row insert in Oracle?</a>  </p>
  </blockquote>
  
  
  
  <p>I have this insert statement</p>
  
  <pre><code>INSERT INTO mytable VALUES 
  ('val1', 'val2'),
  ('aa',   'cc'),
  ('ww',   'dd');
  </code></pre>
  
  <p>and I got this error 
  ORA-00933: SQL command not properly ended</p>