先创建序列,再创建触发器。 例如: /*创建序列*/ create sequence Cj_zj_WYieldRecordSN INCREMENT BY 1 START WITH 1 MINVALUE 0 MAXVALUE 999999999 NOCYCLE NOORDER CACHE 20; /*创建触发器*/ create or replace trigger insert_Cj_zj_WYieldRecordSN before insert on Cj_zj_WarpingYieldRecord referencing old as old new as new for each row begin select Cj_zj_WYieldRecordSN.nextval into :new.SerialNum from dual; end;
例如:
/*创建序列*/
create sequence Cj_zj_WYieldRecordSN
INCREMENT BY 1
START WITH 1
MINVALUE 0
MAXVALUE 999999999
NOCYCLE
NOORDER
CACHE 20;
/*创建触发器*/
create or replace trigger insert_Cj_zj_WYieldRecordSN
before insert on Cj_zj_WarpingYieldRecord
referencing old as old new as new
for each row
begin
select Cj_zj_WYieldRecordSN.nextval into :new.SerialNum from dual;
end;
谢谢!