Home > Database > Mysql Tutorial > 如何使Oracle触发器主键自动增长

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

WBOY
Release: 2016-06-07 17:45:42
Original
773 people have browsed it

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;

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template