create sequence AREA_ID
minvalue 1
maxvalue 6000
start with 1
increment by 1
nocache
order;
创建触发器代码为:
CREATE OR REPLACE TRIGGER AREA_ID
BEFORE INSERT ON XYJ_PROVINCE_CITY_AREA
FOR EACH ROW
BEGIN
SELECT AREA_ID.nextval INTO :new.id FROM dual;
END;
oracle#在PL/SQL设置主键自增长
最新推荐文章于 2024-07-06 00:33:08 发布