SQL> select sequence_name from user_sequences;
創建序列的語法
CREATE SEQUENCE sequence_name
START WITH start_num
INCREMENT BY increment_num
MAXVALUE maximum_num | NOMAXVALUE
MINVALUE minimum_num | NOMINVALUE
CYCLE | NOCYCLE
CACHE cache_num | NOCACHE
ORDER | NOORDER;
查詢序列、
SQL> select sequence_name.nextval from dual;
SQL> select sequence_name.currval from dual;