Oracle 序列-SEQUENCE

序列-SEQUENCE

创建序列

访问序列

序列的修改和删除

DROP SEQUENCE SEQ_EKPO;

查询序列信息

可以通过视图 dba/all/user_sequences 查询序列的相关信息

SELECT SEQUENCE_NAME FROM DBA_SEQUENCES WHERE SEQUENCE_OWNER = 'C##LIUHONGYU';

SELECT SEQUENCE_NAME FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER = 'C##LIUHONGYU';

SELECT SEQUENCE_NAME FROM USER_SEQUENCES;