create sequence tv_seq start with 1 increment by 1;
CREATE OR REPLACE TRIGGER tv_trigger
BEFORE INSERT ON tb_terminal_tv_zol
FOR EACH ROW
WHEN (new.id is null)
begin
select tv_seq.nextval into :new.id from dual;
end;
其中:
-
tv_seq是序列名
-
tv_trigger是触发器名
-
new.id中id是要自增的字段
-
tv_seq.nextval中的tv_seq是对应的序列名
-
触发器名称和序列名称都是自己取名就好
引申:分别删除序列和触发器
drop sequence tv_seq;
drop trigger tv_trigger;