oracle 使用自增列

drop sequence LOG_SEQ;

CREATE  SEQUENCE LOG_SEQ
INCREMENT BY 1 -- 每次加几个
START WITH 1 -- 从1开始计数
NOMAXVALUE -- 不设置最大值
NOCYCLE -- 一直累加，不循环
NOCACHE -- 不建缓冲区

drop trigger RUNNINGLOG_ID_TRIGGER
CREATE OR REPLACE TRIGGER "RUNNINGLOG_ID_TRIGGER" BEFORE
        INSERT ON BEX_LOG_RUNNING FOR EACH ROW  WHEN (new.logid is null)
        declare
        next_checkup_no number;
        begin
        select log_seq.nextval
        into next_checkup_no
        from dual;
        :NEW.logid := next_checkup_no;
       end;