// oracle数据 序列化
create sequence SEQ_kc86_diseaseStatistics
minvalue 1 --最小值
nomaxvalue --不设置最大值
start with 1 --从1开始计数
increment by 1 --每次加1个
nocycle --一直累加,不循环
nocache;
//oracle数据 序列化触发器
CREATE OR REPLACE TRIGGER TIGGER_KC86_DiseaseStatistics
BEFORE
INSERT ON “KC86_DiseaseStatistics”
FOR EACH ROW
WHEN(NEW.ID IS NULL)
BEGIN
SELECT SEQ_kc86_diseaseStatistics.NEXTVAL INTO:NEW.ID FROM DUAL;
END;