oracle sequence 触发器自增

最新推荐文章于 2021-09-08 20:42:13 发布

天下布武の信长

最新推荐文章于 2021-09-08 20:42:13 发布

阅读量173

点赞数

本文链接：https://blog.csdn.net/u011202188/article/details/81260575

版权


-- Create sequence 
create sequence DM.KPI_ITEM_D_SE
minvalue 1
maxvalue 999999999999999999999999999
start with 41
increment by 1
cache 20;


CREATE OR REPLACE TRIGGER DM.KPI_ITEM_DT_TR
  before insert ON DM.KPI_ITEM_D
  for each row
declare
  nextid number;
begin
  IF :new.KPI_ID IS NULL or :new.KPI_ID=0 THEN
    select KPI_ITEM_D_SE.NEXTVAL
    into nextid
    from sys.dual;
    :new.KPI_ID:=nextid;
  end if;
end KPI_ITEM_D_TR;