title: Insert multiple rows with multiple values nextval Oracle SQL
body: <p>I'm trying to insert 2 rows with several values and test_id.nextval into an existing dataframe without including the column headings in the code:</p>
  
  <pre><code>insert into x
      select * from
          (select 12345, 'text', test_id_seq.nextval from dual
      union all
          select 23589, 'other text', test_id_seq.nextval from dual);
  </code></pre>
  
  <p>I got the error: <code>sequence number not allowed here</code>. So I removed the sequence number. Then the error <code>not enough values</code> occured.
  How can I insert multiple rows into an existing table with nextval ids?</p>