--序列
drop sequence REGULATORY_REPORT_SEQ;
create sequence REGULATORY_REPORT_SEQ
minvalue 1 -- 最小值=1
maxvalue 999999999999999999999999999 -- 指定最大值
-- 或nomaxvalue -- 没有最大值
-- NOCYCLE; -- 不循环
start with 1 -- 从1开始
increment by 1 -- 每次递增1
cache 20;
--触发器
drop trigger REGULATORY_REPORT_SEQ;
create or replace trigger REGULATORY_REPORT_SEQ before insert on REGULATORY_REPORT
REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW
begin
SELECT REGULATORY_REPORT_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL;
end;