title: Retrieving CURRVAL and NEXTVAL in a single query
body: <p>Using SQLPlus, I have the following sequence generated:</p>
  
  <pre><code>CREATE SEQUENCE pubnum_seq
  START WITH 7
      INCREMENT BY 2
  MAXVALUE 1000;
  </code></pre>
  
  <p>What I want to do is write a single query that retrieves both the NEXTVAL and the CURRVAL in the sequence. It seems like it should be simple enough. I've tried the following statement:</p>
  
  <pre><code>SELECT pubnum_seq.currval, pubnum_seq.nextval
  FROM dual;
  </code></pre>
  
  <p>However this retrieves the same value for both.</p>
  
  <pre><code>CURRVAL - 7
  NEXTVAL - 7
  </code></pre>
  
  <p>If I try the statements separately, then it gives me what I want, but I'm stump as to how to do this in one query.</p>