欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

如何使Oracle触发器主键自动增长

程序员文章站 2022-06-12 13:40:17
...

1,创建sequence:

  create sequence SEQ_SM_USER

  minvalue 1

  maxvalue 999999999999999999999999999

  start with 1

  increment by 1

  cache 20;

  2,创建触发器:

  create or replace trigger tg_sm_user

  before insert on sm_user

  referencing old as oldval

  new as newval

  for each row

  begin

  select seq_sm_user.nextval into :newval.pk_user from dual;

  end;