CREATE OR REPLACE TRIGGER AUDIT_REC
AFTER INSERT OR DELETE OR UPDATE ON EMPLOYEE_T, SKILL_T
FOR EACH ROW
DECLARE
  V_LOGID NUMBER;
    V_USER  VARCHAR(30);
    V_DATE  VARCHAR(30);

BEGIN
  SELECT EVENTLOG_ID_SEQ.NEXTVAL, USER, SYSDATE INTO V_LOGID, V_USER, V_DATE FROM DUAL;
  IF INSERTING THEN
    INSERT INTO EVENTLOGS(Eventlog_id, User_name, Date_done, Action_done)
    VALUES (V_LOGID, V_USER, V_DATE, 'INSERT');
  ELSIF DELETING THEN
    INSERT INTO EVENTLOGS(Eventlog_id, User_name, Date_done, Action_done)
    VALUES (V_LOGID, V_USER, V_DATE, 'DELETE');
  ELSIF UPDATING THEN
    INSERT INTO EVENTLOGS(Eventlog_id, User_name, Date_done, Action_done)
    VALUES (V_LOGID, V_USER, V_DATE, 'UPDATE');
  END IF;
END;
/