表格名three_pressures
运行如下sql
CREATE SEQUENCE three_seq
minvalue 1
nomaxvalue
START WITH 1
INCREMENT BY 1
NOCACHE
NOCYCLE;
CREATE OR REPLACE TRIGGER threepressures_trigger
BEFORE INSERT ON three_pressures
FOR EACH ROW
BEGIN
:new.id := three_seq.NEXTVAL;
END;
上面的sql是单纯创建序列器,下面的sql是创建一个触发器,触发器名字叫threepressures_trigger,然后关联到表格 three_pressures 的每一行, :new.id :不变, three_seq.NEXTVAL,就是序列器的值;(触发器把表和序列去关联起来)
创建完执行测试一下
insert into three_pressures (wellname,depth) values ('测试1',2368)