序列-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;