--创建序列
create sequence seq_user
start with 1
increment by 1
nomaxvalue
cache 10;
--使用序列
insert into user_table(user_id,user_name,user_pwd) vlaues(seq_user.nextval,'tcy','tcy');
--修改序列
alert sequence seq_user
increment by 5
maxvalue 100000
nocycle
nocache;