title: Sequence error in sql. Sequence number not allowed here
body: <p>I am trying to run the following query to insert a number of nodes with an id that auto-increments as nodes are loaded into the table. </p>
  
  <p>However I get the error, <code>ORA-02287: sequence number not allowed here</code> whenever I run it. </p>
  
  <pre><code>INSERT INTO V1144Engine.T_NODES VALUES
    (
      (SELECT V1144ENGINE.S_PK_NODES.NEXTVAL FROM dual),
      1,
      'Chemistry of Life',
      0,1,
      SYSDATE,
      NULL,
      'CON.3.1',
      NULL
    );
  </code></pre>
  
  <p>I have tried running </p>
  
  <pre><code>SELECT V1144ENGINE.S_PK_NODES.NEXTVAL from dual
  </code></pre>
  
  <p>This works fine and returns the number that I want. </p>
  
  <p>How do I get around this? I am running on Oracle 11g. </p>
  
  <p>Also it would be much appreciated if the query were still runnable on one line as I am making these in a spreadsheet and would like to still be able to do so.</p>