title: Insert All causes unique constraint of primary key violated
body: <p>I am trying to use INSERT ALL to insert rows in my table.</p>
  
  <pre><code>INSERT ALL
  INTO TABLE(C2, C3) VALUES ("Hello","World")
  ...
  ...
  SELECT 1 from DUAL;
  </code></pre>
  
  <p>Column C1 of the table has constraint of primary key and its value is set as default next value of a sequence I created (this was done while table creation),</p>
  
  <pre><code>C1 NUMBER(10,0) DEFAULT SEQUENCE1.NEXTVAL NOT NULL,
  .
  .
  CONSTRAINT Constraint1 PRIMARY KEY (C1)
  </code></pre>
  
  <p>While running the insert all statemnt I get the error</p>
  
  <blockquote>
    <p>ORA-00001: unique constraint (databaseName.Constraint1 ) violated</p>
  </blockquote>
  
  <p>Does it happen because insert all does some synced up insertion and the sequence is not increasing?
  I am trying to use Insert ALL only for fresh insertion (not copying from source to destination table)
  I do not want to use Insert query for each row.
  This is some research kind of thing I am trying.</p>