创建以及查看sequence

create sequence XXXXX

minvalue 1

maxvalue 999999999999

start with 1

increment by 1

nocache;

 

SELECT LAST_NUMBER,INCREMENT_BY FROM USER_SEQUENCES WHERE SEQUENCE_NAME='XXXX'