3,490
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE TRIGGER tr_reg_cou
AFTER INSERT ON testa FOR EACH ROW
DECLARE
v_exist_count INTEGER := 0;
BEGIN
SELECT COUNT(0) INTO v_exist_count
FROM testa
WHERE cid =:new.cid;
IF v_exist_count > 0 THEN
insert into testb (bid,nameb,xbb) values(:new.cid,:new.name,:new.xb);
COMMIT;
END IF;
END tr_reg_cou;
CREATE OR REPLACE TRIGGER tr_reg_cou
AFTER
INSERT
on testa
FOR EACH ROW
--when (new.cid in (6,7,8))
BEGIN
if exists(select 1 from testa where cid =:new.cid) then
BEGIN
insert into testb (bid,nameb,xbb) values(:new.cid,:new.name,:new.xb);
commit;
end;
end if;
END;