17,078
社区成员
发帖
与我相关
我的任务
分享
create or replace trigger "T_JGXX_TEST"
before INSERT OR UPDATE OF "IN_CODE","XTLB","JGLX","GLXS","SSQH" ON "TEST"."A10_JGXX"
FOR EACH ROW
DECLARE
TREEVAR VARCHAR2(200);
v_tree VARCHAR2(100);
BEGIN
if length(:new.IN_CODE)!=4 then
select tree_code
into v_tree
from a10_jgxx
where in_code = substr(:new.IN_CODE,0,length(:new.IN_CODE)-4);
:new.tree_code := v_tree ||'-5'||:new.IN_CODE;
end if;
END;