//先设置最小起点 最大值 起步值 自增值 缓存值
create sequence tb_emergencyrefuge_seq
minvalue 1maxvalue 999999999999999999999999999
start with 2000
increment by 1
cache 20;
//设置要自增的字段 让每次insert 可以为null
CREATE OR REPLACE TRIGGER emergencyrefuge_INS_TRG BEFORE INSERT ON tb_emergencyrefuge FOR EACH ROW WHEN(NEW.REFUGEID IS NULL)
BEGIN
SELECT tb_emergencyrefuge_seq.NEXTVAL INTO :NEW.REFUGEID FROM DUAL;
END;