Oracle 数据库主键ID设置自增

最新推荐文章于 2024-08-16 10:17:19 发布

@三块五毛

最新推荐文章于 2024-08-16 10:17:19 发布

阅读量267

点赞数 3

文章标签： oracle 数据库

本文链接：https://blog.csdn.net/qq_43137834/article/details/139146320

版权

SysUserKeyValue是需要设置的表

CREATE SEQUENCE SysUserKeyValue_ID
    START WITH 1
    INCREMENT BY 1
    NOMINVALUE
    MAXVALUE 9999999999999999999999999999
    NOCYCLE
    NOORDER
    NOCACHE;


CREATE OR REPLACE TRIGGER SysUserKeyValue_ID
BEFORE INSERT ON SysUserKeyValue
REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW
DECLARE
BEGIN
SELECT SysUserKeyValue_ID.nextval INTO :NEW.ID FROM DUAL;
END SysUserKeyValue_ID;