--创建自增ID,名称为:表名_字段名_SEQ
CREATE SEQUENCE T_BASE_BRIDGE_ID_SEQ MINVALUE 1 NOMAXVALUE INCREMENT BY 1 START WITH 1 NOCACHE;
-- 为Insert操作创建触发器,无需在SQL语句里写NEXTVAL,名称为表名_INS_TRG
CREATE OR REPLACE TRIGGER T_BASE_BRIDGE_INS_TRG BEFORE INSERT ON T_BASE_BRIDGE FOR EACH ROW WHEN(NEW.ID IS NULL)
BEGIN
SELECT T_BASE_BRIDGE_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
END;
oracle 实现ID自增
最新推荐文章于 2024-02-05 09:01:32 发布