title: How can I do multiple insert using TOAD?
body: <p>I'm trying to do multiple insert in TOAD. The query below executes just fine (the bar below shows that commit has been done), but when I check the database there are no new values. What am I doing wrong?</p>
  
  <p>The query:</p>
  
  <pre><code>INSERT ALL 
  INTO db1.t1 (col1, col2, col3, col4, col5)
  VALUES ('blah', 'Answer', 'Y', 'Y', 5)
  INTO db1.t1 (col1, col2, col3, col4, col5)
  VALUES ('blah', '# answers', 'Y', 'Y', 6)
  SELECT * FROM DUAL;
  COMMIT;
  </code></pre>