title: Sequence next value in SELECT statement
body: <p>I would like to use the same sequence number across multiple select statements 
  in SQL form to eventually use it as a PK insert in a table and tie multiple records together.</p>
  
  <p>So far, I can only select the NEXTVAL from dual:</p>
  
  <pre><code>SELECT TEST_SEQ.NEXTVAL AS SEQ FROM DUAL;
  </code></pre>
  
  <p>However, when I include the sequence into a multiple column select, I get sequence not allowed here error. </p>
  
  <pre><code>SELECT col1, co2, col3, (select TEST_SEQ.NEXTVAL) SEQ
  FROM table; 
  </code></pre>
  
  <p>Any help is greatly appreciated. </p>