- 创建一个序列
create sequence seq_hyqf_warn_dumping minvalue 1 maxvalue 999999999999999999 start with 1 increment by 1 nocache
- 创建一个触发器
create or replace trigger seq_hyqf_warn_dumping
before insert on HYQF_WARN_DUMPING
for each row
begin
select seq_hyqf_warn_dumping.nextval into :new.OBJECTID from dual;
end;
- 删除序列
DROP SEQUENCE seq_hyqf_warn_dumping;