помогите правильно написать триггер! please!
CREATE OR REPLACE TRIGGER "PHONES_CHECK_ST_T"
AFTER
insert on "PHONES_CHECK"
for each row
begin
IF (:NEW.PHONE_NUM != :OLD.PHONE_NUM) THEN
INSERT INTO STATEMENT (PHONE_NUM, ACTION, UP_DATE)
VALUES (:NEW.PHONE_NUM, :NEW.ACTION, :NEW.UP_DATE);
END IF;
IF (:NEW.PHONE_NUM = :OLD.PHONE_NUM) THEN
UPDATE STATEMENT
SET STATEMENT.ACTION = :NEW.ACTION,
STATEMENT.UP_DATE = :NEW.UP_DATE;
END IF;
end;
/