oracle 序列的使用

新建序列

CREATE SEQUENCE  "YIBAO"."seq_mobilelist_rlog_tmp"  MINVALUE 1 MAXVALUE 99999999999999999999999 INCREMENT BY 1 START WITH 16437 CACHE 20 NOORDER  NOCYCLE ;

 

使用序列

insert into MOBILELIST_RLOG_TMP (seq,COUNT_DATE) VALUES ("seq_mobilelist_rlog_tmp".nextVal,cm_mobilelist_rlog.sendtime);