急~~~~大哥们都来看一下这个触发器!急~~~~
大哥们都来看一下这个触发器!ORale的触发器怎么修改成SQL的啊!!
ORale的触发器下面:
create or replace trigger TIA_CKH_ZB after insert
on PMIS.CKH_ZB for each row
begin
insert into ckclb( bm,pm) Values (nvl(:new.ckh,'')||nvl(:new.zbh,''),nvl(:new.zbmc,''));
end;