CREATE OR REPLACE TRIGGER ejer5

after INSERT OR DELETE ON ciclista

FOR each ROW

DECLARE

    v_hora auditar.hora%TYPE;
    v_operacion VARCHAR2(6);

BEGIN

    IF (USER != 'SYSTEM') THEN

    SELECT TO_CHAR(SYSDATE, 'HH24:MI:SS') INTO v_hora FROM dual;

        IF inserting THEN

            v_operacion := 'Insert';

        END IF;

        IF deleting THEN

            v_operacion := 'Delete';

        END IF;

        INSERT INTO auditar VALUES (USER, SYSDATE, v_hora, v_operacion);

    END IF;

END;
/