select * from user_sequences;
/*第二步:建立自定义的sequence*/
drop SEQUENCE K_CONFIG_DIAGNOSE_TYPE_SEQ;
CREATE SEQUENCE K_CONFIG_ACTIVITY_TYPE_SEQ
increment by 1 -- 每次加几个
start with 1 -- 从1开始计数
nomaxvalue -- 不设置最大值
nocycle -- 一直累加,不循环
nocache; -- 不建缓冲区
/*第三步:建立触发器*/
create trigger K_CONFIG_ACTIVITY_TYPE_trig before
insert on K_CONFIG_ACTIVITY_TYPE for each row when (new.id is null)
begin
select K_CONFIG_ACTIVITY_TYPE_SEQ.nextval into:new.id from dual;
end;
oracle生成主键的方法
最新推荐文章于 2021-04-15 16:50:46 发布