oracle触发器随记

表设置触发器，

create sequence Increase_Sequence
minvalue 1
nomaxvalue
increment by 1
start with 1
nocache;

create or replace trigger dev_alert_config_trigger
before insert on OS_DEVICE_MANAGE_MIGRATE.dev_alert_config
for each row
begin
select Increase_Sequence.nextval into :new.id from dual;
end;