1、创建序列
CREATE SEQUENCE ALART_INFO_IDINC_SEQUENCE INCREMENT BY 1 -- 每次递增1
START WITH 1 -- 从1开始
NOMAXVALUE -- 没有最大值
MINVALUE 1 -- 最小值=1
NOCYCLE; -- 不循环
2、创建触发器
CREATE OR REPLACE TRIGGER ALART_INFO_IDINC_TRIGGER BEFORE INSERT ON "ALART_INFO" FOR EACH ROW
BEGIN
SELECT
"ALART_INFO_IDINC_SEQUENCE".nextval INTO:NEW.ID
FROM
dual;
END;