create sequence test1
minvalue 1
maxvalue 9999
start with 1
increment by 1
nocache;
创建test1序列
minvalue 1
maxvalue 9999
start with 1
increment by 1
nocache;
创建test1序列
select test1.nextval from sys.dual;
查询test1序列,每次查询加1