ALL_SEQUENCES

📄字数 858

👁️阅读量 加载中...

功能描述

ALL_SEQUENCES系统视图用于存储和管理创建的序列值信息。

字段说明

序号	字段名	类型	说明	V11	V12
0	DB_ID	INTEGER	库ID	√	√
1	SCHEMA_ID	INTEGER	模式ID	√	√
2	USER_ID	INTEGER	属主ID	√	√
3	SEQ_ID	INTEGER	序列值ID	√	√
4	SEQ_NAME	VARCHAR	序列值产生器的名称	√	√
5	IS_CYCLE	BOOLEAN	是否循环	√	√
6	IS_ORDER	BOOLEAN	是否有序	√	√
7	CACHE_VAL	INTEGER	是否缓存一些序列值	√	√
8	CURR_VAL	BIGINT	当前值	√	√
9	MAX_VAL	BIGINT	最大值	√	√
10	MIN_VAL	BIGINT	最小值	√	√
11	STEP_VAL	BIGINT	增长步长	√	√
12	CREATE_TIME	DATETIME	创建时间	√	√
13	IS_SYS	BOOLEAN	是否系统内建	√	√
14	VALID	BOOLEAN	是否有效	√	√
15	COMMENTS	VARCHAR	注释信息	√	√
16	RESERVED1	VARCHAR	保留字段	√	√
17	RESERVED2	VARCHAR	保留字段	√	√
18	SEQUENCE_NAME	VARCHAR	序列值产生器的名称	x	√

应用举例

• 查询系统序列相关信息

SQL> CREATE SEQUENCE seq_test MINVALUE 10 MAXVALUE 1000 START WITH 20 INCREMENT BY 10 CACHE 5 COMMENT 'test sequence to be modified';

SQL> SELECT * FROM ALL_SEQUENCES WHERE seq_name='SEQ_TEST';
+-------+-----------+---------+---------+----------+----------+----------+-----------+----------+---------+---------+----------+--------------------------+--------+--------+------------------------------+-----------+-----------+---------------+
| DB_ID | SCHEMA_ID | USER_ID | SEQ_ID  | SEQ_NAME | IS_CYCLE | IS_ORDER | CACHE_VAL | CURR_VAL | MAX_VAL | MIN_VAL | STEP_VAL |       CREATE_TIME        | IS_SYS | VALID  |           COMMENTS           | RESERVED1 | RESERVED2 | SEQUENCE_NAME |
+-------+-----------+---------+---------+----------+----------+----------+-----------+----------+---------+---------+----------+--------------------------+--------+--------+------------------------------+-----------+-----------+---------------+
| 1     | 1         | 1       | 1048597 | SEQ_TEST | F        | <NULL>   | 5         | 20       | 1000    | 10      | 10       | 2025-06-26 09:42:03.650  | F      | <NULL> | test sequence to be modified | <NULL>    | <NULL>    | SEQ_TEST      |
+-------+-----------+---------+---------+----------+----------+----------+-----------+----------+---------+---------+----------+--------------------------+--------+--------+------------------------------+-----------+-----------+---------------+

相关系统表

• SYS_SEQUENCES
• SYS_SCHEMAS