Sequence Information

DESCRIBE user_sequences;

Name	Null?	Type
SEQUENCE_NAME	NOT NULL	VARCHAR2(30)
MIN_VALUE		NUMBER
MAX_VALUE		NUMBER
INCREMENT_BY	NOT NULL	NUMBER
CYCLE_FLAG		VARCHAR2(1)
ORDER_FLAG		VARCHAR2(1)
CACHE_SIZE	NOT NULL	NUMBER
LAST_NUMBER	NOT NULL	NUMBER

• CYCLE_FLAG : Does sequence wrap around on reaching limit?
• ORDER_FLAG : Are sequence numbers generated in order?
• LAST_NUMBER : Last sequence number written to disk. If a sequence uses caching, the last number in cache will be written.
  

SELECT sequence_name, min_value, max_value, increment_by, last_name FROM user_sequence;

SEQUENCE_NAME	MIN_VALUE	MAX_VALUE	INCREMENT_BY	LAST_NUMBER
LOCATIONS_SEQ	1	9900	100	3300
DEPARTMENTS_SEQ	1	9990	10	280
EMPLOYEES_SEQ	1	1.0000E+27	1	207
DEPT_DEPTID_SEQ	1	9999	10	130
DEPT_ID_SEQ	1	1000	10	260

Viewing the Next available sequence value without incrementing it.   
  - If NOCACHE is specified, the next available sequence number  will be written.