摘要:
create or replace trigger ADDCSUTSAME before insert on bd_cubasdoc for each rowdeclare -- local variables here pk_bas varchar2(200); cursor basjob(id varchar2)is select custname from bd_cubasdoc where custname=id and nvl(dr,0)=0 and custname in (select custname from bd_cubasdoc) /*and len... 阅读全文
摘要:
create or replace trigger S_UPDATE_CUSTBANK before update on bd_custbank for each rowdeclare -- local variables here pk_bas char(20); cursor basjob(id char) is select pk_custbank from ncv5.bd_custbank /*目标数据库表*/ where pk_custbank = id and nvl(dr, 0) = 0;begin /*判断数据是否在目标数... 阅读全文