PLSQL Trigger FOR EACH ROW


CREATE OR REPLACE TRIGGER   _  _TRIG AFTER
  INSERT ON    FOR EACH ROW BEGIN
  UPDATE    SET     =     - :NEW.    WHERE     = :NEW.   ;
END;
DECLARE
  V_  ID   .  ID%TYPE;
BEGIN
  PROC_    ('  ID',V_  ID); -- <>
  INSERT INTO   
    (  ID,    ,   
    ) VALUES
    (V_  ID, 'テレビ', 2
    );-- <>
  COMMIT;
END;
/