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;
……
[/Quote]
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
;