Oracle资料之sequence

◆ 获取sequence下一个值

select sequence.nextval from dual;

◆ sequence视图：

ALL_SEQUENCES

视图含义：

ALL_SEQUENCES describes all sequences accessible to the current user.

相关视图：

1、DBA_SEQUENCES describes all sequences in the database.

2、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(30)	NOT NULL	Name of the owner of the sequence
SEQUENCE_NAME	VARCHAR2(30)	NOT NULL	Sequence name
MIN_VALUE	NUMBER		Minimum value of the sequence
MAX_VALUE	NUMBER<