oracle sequence操作

新建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;