当前位置:数据库 > Oracle >>

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

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;

补充:数据库,Oracle教程
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,