oracle 数据库触发器实现主键自增

1.为表的主键创建一个 SEQUENCE

CREATE SEQUENCE ID_SEQ
INCREMENT BY 1
START WITH 1 
NOMAXVALUE
NOCACHE;

2.创建一个触发器

CREATE OR REPLACE TRIGGER ID_AUTOINCREMENT BEFORE
INSERT ON TEST_TABLE -- 表名
FOR EACH ROW
WHEN(NEW.ID IS NULL)
BEGIN
	SELECT ID_SEQ.NEXTVAL INTO:NEW.ID FROM DUAL;
END;