[Home] [Help] [Dependency Information]
Object Name: | ALL_SEQUENCES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Description of SEQUENCEs accessible to the user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQUENCE_OWNER | VARCHAR2 | (128) | Yes | Name of the owner of the sequence |
SEQUENCE_NAME | VARCHAR2 | (128) | Yes | SEQUENCE name |
MIN_VALUE | NUMBER | Minimum value of the sequence | ||
MAX_VALUE | NUMBER | Maximum value of the sequence | ||
INCREMENT_BY | NUMBER | Yes | Value by which sequence is incremented | |
CYCLE_FLAG | VARCHAR2 | (1) | Does sequence wrap around on reaching limit? | |
ORDER_FLAG | VARCHAR2 | (1) | Are sequence numbers generated in order? | |
CACHE_SIZE | NUMBER | Yes | Number of sequence numbers to cache | |
LAST_NUMBER | NUMBER | Yes | Last sequence number written to disk | |
PARTITION_COUNT | NUMBER | Partition Count if sequence is partitioned | ||
SESSION_FLAG | VARCHAR2 | (1) | Is this a session sequence? | |
KEEP_VALUE | VARCHAR2 | (1) | Are sequence values kept during replay after failure |
Cut, paste (and edit) the following text to query this object:
SELECT SEQUENCE_OWNER
, SEQUENCE_NAME
, MIN_VALUE
, MAX_VALUE
, INCREMENT_BY
, CYCLE_FLAG
, ORDER_FLAG
, CACHE_SIZE
, LAST_NUMBER
, PARTITION_COUNT
, SESSION_FLAG
, KEEP_VALUE
FROM SYS.ALL_SEQUENCES;
|
|
|