Oracle自增设置
触发器格式:
create or replace trigger [触发器名字]
before insert on [数据表名字]
for each row
declare
nextid number;
begin
IF :new.[自增的列名] IS NULL or :new.[自增的列名]=0 THEN
select [序列名].nextval
into nextid
from sys.dual;
:new.[自增的列名]:=nextid;
end if;
end [触发器名字];
触发器创建时不可使用commit
序列格式:
create sequence [序列名]
minvalue 1 --最小值
maxvalue 99 --最大值
start with 1 --起始值
increment by 1 --每次增量
nocache; --缓存
commit;