title: insert multiple row into table using select however table has primery key in oracle SQL
body: <p>I am facing issue while inserting multiple row in one go into table because column id has primary key and its created based on sequence.</p>
  
  <p>for ex:</p>
  
  <pre><code>create table test (
    iD number primary key,
    name varchar2(10)
  );
  
  
  insert into test values (123, 'xxx');
  insert into test values (124, 'yyy');
  insert into test values (125, 'xxx');
  insert into test values (126, 'xxx');
  </code></pre>
  
  <p>The following statement creates a constraint violoation error:</p>
  
  <pre><code>insert into test
  (
     select (SELECT MAX (id) + 1 FROM  test) as id,
     name from test
    where name='xxx'
   );
  </code></pre>
  
  <p>This query should insert 3 rows in table test (having name=xxx).</p>