数据库多个触发器的连续执行

---- 1：部门中间表序列触发器
create or replace trigger MID_ORG_DEPT_TRIGGER
before insert on mid_org_dept
for each row
begin
  if (:new.mid_id is null) then
    select MID_ORG_DEPT_ID.nextval into :new.mid_id from dual;
  end if;
end;
/
----2：个人银行账户中间表创建序列触发器
create or replace trigger mid_bd_psnbankacc_trig_autoinc
before insert on mid_bd_psnbankacc
for each row
begin
  if (:new.mid_id is null) then   
    select mid_bd_psnbankacc_id.nextval into :new.mid_id from dual;
  end if;
end;
/
 ----3：个人银行子账户中间表创建序列触发器
create or replace trigger mid_bd_bankaccsub_trig_autoinc
before insert on mid_bd_bankaccsub 
for each row
begin
  if (:new.mid_id is null) then   
    select mid_bd_bankaccsub_id.nextval into :new.mid_id from dual;
  end if;
end;