主键自增长

一)建立序列:
create sequence SMSLOG_SEQ2
minvalue 1
maxvalue 999999999999999999
start with 601
increment by 1
cache 20;
二)建立触发器:
CREATE OR REPLACE TRIGGER "smslog_trig3"
   BEFORE INSERT ON smslog
  REFERENCING OLD AS OLD NEW AS NEW  FOR EACH ROW
DECLARE
BEGIN
  SELECT smslog_seq.NEXTVAL INTO :NEW.ID FROM DUAL;
END smslog_trig;
三)建立表:
create table SMSLOG2
(
   ID       NUMBER not null,
   USERID   NUMBER,
   USERNAME VARCHAR2(200),
   DEPTID   NUMBER
)