title: how to multi-row insert in Oracle with sequence?
body: <p>I want insert more than one row into table in Oracle . But it's confused me :
  I can not use </p>
  
  <pre><code>select seq_table1.nextval  into table1 form dual
  </code></pre>
  
  <p>because the the table1 need be a new one. I need insert  some rows into the exist table1.  </p>
  
  <p>And I  also can  not use  </p>
  
  <pre><code>insert into pager (PAG_ID,PAG_PARENT,PAG_NAME,PAG_ACTIVE)
            (select seq_paper.nextval,'Multi 8000',1 from dual
   union all select seq_paper.nextval,'Multi 8001',1 from dual)
  </code></pre>
  
  <p>because oracle tell me that:</p>
  
  <pre><code>Restrictions on Sequence Values You cannot use CURRVAL and NEXTVAL in the  
  following constructs:  
  ■ A SELECT statement that is combined with another SELECT statement with the  
  UNION, INTERSECT, or MINUS set operator ;
  ...and other constructs
  </code></pre>