title: Inserting multiple rows in a single Oracle SQL query:
body: <p>Inserting multiple rows in a single Oracle SQL query. Here is the following query I am trying to use. Can anyone tell me the error that I am having and how to go about it. Thanks.</p>
  
  <pre><code>INSERT ALL INTO 
       "SCOTT"."GREATCOLOR1" (
             COLOR, 
             PAUL, 
             JOHN, 
             TIM, 
             ERIC
       )VALUES (
             'White', 
             '1', 
             '5', 
             '1', 
             '3') 
       INTO "SCOTT"."GREATCOLOR1" (
             COLOR, 
             PAUL, 
             JOHN, 
             TIM, 
             ERIC
      )VALUES (
             'Yello', 
             '8', 
             '4', 
             '3', 
             '5') 
      INTO "SCOTT"."GREATCOLOR1" (
             COLOR, 
             PAUL, 
             JOHN, 
             TIM, 
             ERIC
      ) VALUES (
             'Black', 
             '2', 
             '2', 
             '9', 
             '1') 
      SELECT * FROM dual;
  </code></pre>