---- 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;
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;