oracle建序列再建触发器

序列

CREATE SEQUENCE SY_PE_YWSJ_ZYBZX0_ZXID00
 START WITH 1
 INCREMENT BY 1
 MINVALUE 1
 MAXVALUE 999999
 CACHE  20

触发器

create or replace trigger "TRI_SY_PE_YWSJ_ZYBZX0"
before insert on SY_PE_YWSJ_ZYBZX0
 for each row
begin
select  SY_PE_YWSJ_ZYBZX0_ZXID00.nextval into :new.ZXID00 from dual;
end;