Oracle教程 2023-02-23

Oracle 视图 ALL_SEQUENCES 官方解释，作用，如何使用详细说明

Oracle视图ALL_SEQUENCES用于查看当前用户拥有权限的所有序列。它显示了当前用户拥有权限的序列应用信息，如用户、表空间、创建时间、最新数字、最大值、最小值、循环模式等。ALL_SEQUENCES视图中的每一个序列都是一个对象，它具有不同的属性和功能参数。

使用方式：
例：查看当前用户有权访问的序列
SELECT * from ALL_SEQUENCES;

例：查询指定序列的最大值
SELECT MAX_VALUE FROM ALL_SEQUENCES WHERE SEQUENCE_NAME = ‘sequence_name’;

ALL_SEQUENCES describes all sequences accessible to the current user.

Related Views

DBA_SEQUENCES describes all sequences in the database.
USER_SEQUENCES describes all sequences owned by the current user. This view does not display the SEQUENCE_OWNER column.

Column	Datatype	NULL	Description
`SEQUENCE_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the sequence
`SEQUENCE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Sequence name
`MIN_VALUE`	`NUMBER`		Minimum value of the sequence
`MAX_VALUE`	`NUMBER`		Maximum value of the sequence
`INCREMENT_BY`	`NUMBER`	`NOT NULL`	Value by which sequence is incremented
`CYCLE_FLAG`	`VARCHAR2(1)`		Indicates whether the sequence wraps around on reaching the limit (`Y`) or not (`N`)
`ORDER_FLAG`	`VARCHAR2(1)`		Indicates whether sequence numbers are generated in order (`Y`) or not (`N`)
`CACHE_SIZE`	`NUMBER`	`NOT NULL`	Number of sequence numbers to cache
`LAST_NUMBER`	`NUMBER`	`NOT NULL`	Last sequence number written to disk. If a sequence uses caching, the number written to disk is the last number placed in the sequence cache. This number is likely to be greater than the last sequence number that was used. For session sequences, the value in this column should be ignored.
`SCALE_FLAG`	`VARCHAR2(1)`		Indicates whether this is a scalable sequence (`Y`) or not (`N`)
`EXTEND_FLAG`	`VARCHAR2(1)`		Indicates whether this scalable sequence’s generated values extend beyond `MAX_VALUE` or `MIN_VALUE` (`Y`) or not (`N`)
`SHARDED_FLAG`	`VARCHAR2(1)`		Indicates whether this is a sharded sequence (`Y`) or not (`N`)
`SESSION_FLAG`	`VARCHAR2(1)`		Indicates whether sequence values are session private (`Y`) or not (`N`)
`KEEP_VALUE`	`VARCHAR2(1)`		Indicates whether sequence values are kept during replay after a failure (`Y`) or not (`N`)