oracle 应用自增列

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;