create or replace TRIGGER TR_TEST1 AFTER INSERT ON TAB1 FOR EACH ROW DECLARE V_COUNT NUMBER;V_ID NUMBER;V_NAME VARCHAR2(10); BEGIN SELECT COUNT(*) INTO V_COUNT FROM TAB2 WHERE id=:new.id; IF V_COUNT=1 THEN SELECT ID,NAME INTO V_ID,V_NAME FROM TAB2 WHERE id=:new.id; INSERT INTO TAB3 VALUES(V_ID,V_NAME); ELSE NULL; END IF; END ;
AFTER INSERT ON TAB1
FOR EACH ROW
DECLARE V_COUNT NUMBER;V_ID NUMBER;V_NAME VARCHAR2(10);
BEGIN
SELECT COUNT(*) INTO V_COUNT FROM TAB2 WHERE id=:new.id;
IF V_COUNT=1 THEN
SELECT ID,NAME INTO V_ID,V_NAME FROM TAB2 WHERE id=:new.id;
INSERT INTO TAB3 VALUES(V_ID,V_NAME);
ELSE NULL;
END IF;
END
;