CREATE SEQUENCE SEQ_PRODUCT_STANDARD_CHG START WITH 1 -- 从1开始计数 NOMAXvalue -- 不设置最大值 INCREMENT BY 1 -- 每次加几个 NOCYCLE -- 一直累加,不循环 CACHE 10;
select Svc_Sign_Seq.Nextval from dual;
select Svc_Sign_Seq.Currval from dual;
CREATE SEQUENCE SEQ_PRODUCT_STANDARD_CHG START WITH 1 -- 从1开始计数 NOMAXvalue -- 不设置最大值 INCREMENT BY 1 -- 每次加几个 NOCYCLE -- 一直累加,不循环 CACHE 10;
select Svc_Sign_Seq.Nextval from dual;
select Svc_Sign_Seq.Currval from dual;