ALL_SEQUENCES

Description of SEQUENCEs accessible to the user

Columns
   ___________________________
 
   INCREMENT_BY
      Value by which sequence is incremented
   CYCLE_FLAG
      Does sequence wrap around on reaching limit?
   LAST_NUMBER
      Last sequence number written to disk
   CACHE_SIZE
      Number of sequence numbers to cache
   MAX_VALUE
      Maximum value of the sequence
   MIN_VALUE
      Minimum value of the sequence
   SEQUENCE_NAME
      SEQUENCE name
   SEQUENCE_OWNER
      Name of the owner of the sequence
   ORDER_FLAG
      Are sequence numbers generated in order?

Related Commands:

Simon Sheppard
SS64.com