ORACLE创建自增长主键

最新推荐文章于 2024-06-13 16:03:17 发布

原创最新推荐文章于 2024-06-13 16:03:17 发布 · 506 阅读

CC 4.0 BY-SA版权

drop table INSTITUTION_CATEGORY;
create table INSTITUTION_CATEGORY(
       ID number(5) not null primary key,
       NAME varchar2(50) not null,
       PARENT_ID number(5),
       IS_VALID varchar2(2) default '1',
       CREATE_DATE	TIMESTAMP(6),
       CREATER varchar2(20)
);

drop sequence INSTITUTION_CATEGORY_SEQUENCE;
create sequence INSTITUTION_CATEGORY_SEQUENCE
minvalue 1
maxvalue 999999999
start with 1
increment by 1
cache 20;

create or replace trigger INSTITUTION_CATEGORY_TRIGGER                    
before insert on INSTITUTION_CATEGORY  /*触发条件*/    
for each row     /*对每一行都检测是否触发*/    
begin   /*触发器开始*/    
select  INSTITUTION_CATEGORY_SEQUENCE.nextval into :new.ID from dual;   
/*触发器主题内容，即触发后执行的动作，在此是取得INSTITUTION_CATEGORY_SEQUENCE序列下一个值插入到表ID字段中*/    
end;