--创建自增ID,名称为:表名_字段名_SEQ CREATE SEQUENCE testTable1_ID_SEQ MINVALUE 1 NOMAXVALUE INCREMENT BY 1 START WITH 1 NOCACHE; -- 为Insert操作创建触发器,无需在SQL语句里写NEXTVAL,名称为表名_INS_TRG CREATE OR REPLACE TRIGGER testTable1_INS_TRG BEFORE INSERT ON testTable1 FOR EACH ROW WHEN(NEW.ID IS NULL) BEGIN SELECT testTable1_ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL; END;
ORACLE id自增长
最新推荐文章于 2024-07-25 16:26:05 发布