1. 创建sequence:
CREATE sequence "自定义序列名称" minvalue 1 nomaxvalue INCREMENT BY 1 START WITH 1 nocache;
例子:
CREATE sequence SCHEDULE_JOB_ID minvalue 1 nomaxvalue INCREMENT BY 1 START WITH 1 nocache;
2. 创建触发器:
CREATE
OR REPLACE TRIGGER "自定义触发器名称" before INSERT ON "要自增的表" FOR each ROW
BEGIN
SELECT
"上一步创建的序列名".Nextval INTO : new."需要自增的表的主键"
FROM
dual END;
例子:
CREATE
OR REPLACE TRIGGER SCHEDULE_JOB_insertId before INSERT ON SCHEDULE_JOB FOR each ROW
BEGIN
SELECT
SCHEDULE_JOB_ID.Nextval INTO : new.LOG_ID
FROM
dual END;