CREATE OR REPLACE TRIGGER trig_obn_audit AFTER UPDATE OR DELETE OR INSERT ON ZP_STUDENTS FOR EACH ROW
BEGIN
  DECLARE
  b ZP_AUDIT.IZM_TYPE%TYPE;
    BEGIN
      if updating THEN b:='обновление';
      ELSIF deleting THEN b:='удаление';
      ELSIF inserting THEN b:='вставка';
      END IF;
    END;

  IF :NEW.TABN<>:OLD.TABN THEN 
      INSERT INTO ZP_AUDIT (
      KOD, ST_TABN, N_TABN, IZM_TYPE, IZM_BY, DATAIZM
      )
      VALUES (trig_seq.NEXTVAL, :OLD.TABN, :NEW.TABN, b, USER, SYSDATE); 
  END IF;
END;

CREATE OR REPLACE TRIGGER trig_obn_audit AFTER UPDATE OR DELETE OR INSERT ON ZP_STUDENTS FOR EACH ROW
BEGIN
        if updating THEN INSERT INTO ZP_AUDIT (
  KOD, ST_TABN, N_TABN, IZM_TYPE, IZM_BY, DATAIZM
)
VALUES (trig_seq.NEXTVAL, :NEW.TABN, :OLD.TABN, 'обновление', USER, SYSDATE);
        ELSIF deleting THEN INSERT INTO ZP_AUDIT (
  KOD, ST_TABN, N_TABN, IZM_TYPE, IZM_BY, DATAIZM
)
VALUES (trig_seq.NEXTVAL,:OLD.TABN , NULL, 'удаление', USER, SYSDATE);
        ELSIF inserting THEN INSERT INTO ZP_AUDIT (
  KOD, ST_TABN, N_TABN, IZM_TYPE, IZM_BY, DATAIZM
)
VALUES (trig_seq.NEXTVAL, NULL, :NEW.TABN, 'вставка', USER, SYSDATE);
        END IF;
END;