新建sequence:
CREATE SEQUENCE S_SMSRECORDID
START WITH 1
INCREMENT BY 1
NOMINVALUE
NOMAXVALUE
CACHE 20
NOORDER
;
使用sequence:
插入时:
INSERT INTO emp VALUES
(empseq.nextval, 'LEWIS', 'CLERK',7902, SYSDATE, 1200, NULL, 20);
单独查询时:
SELECT empseq.nextval FROM DUAL;
返回当前值:CURRVAL
SELECT empseq.CURRVAL FROM DUAL;