title: Can we specify no of cycles in sequences in oracle?
body: <p>I started to create a sequence in Oracle. While going through the oracle documentation I got this prototype </p>
  
  <pre><code>Create Sequence SeqTest5
  Start With 0
  Increment by 1
  Min value 0
  Maxvalue 8
  NoCycle    --I got to know we can give this as 'Cycle' which will again
             -- Repeat the loop. But my doubt is why cannot we specify  number of 
             -- Loops. Such as Cycle 20             
  NoCache    --I got to know we can give certain buffer lenght via cache
  </code></pre>
  
  <p>Can you Please explain me why cannot we declare it as I have tried it and got this error</p>
  
  <pre><code>1  create sequence seqtest4
  2  cache 30,
  3* cycle 20,
  SQL&gt; /
  cache 30,
      *
  ERROR at line 2:
  ORA-00933: SQL command not properly ended
  </code></pre>
  
  <p>For Example:-</p>
  
  <pre><code>TNUM
       0
       1
       4
       2
       3
       5
       6
       7
       8
  </code></pre>
  
  <p>This 0-8 should write 10 times and stop.</p>