CREATE OR REPLACE TRIGGER login AFTER logon ON HR.schema BEGIN
INSERT INTO log_users (usuario,tipo,fecha)
VALUES (USER,
        'normal',
        sysdate); IF to_char (sysdate,'HH24:MI') NOT BETWEEN '08:00' AND '18:00'
OR to_char (sysdate, 'DY') IN ('SAT',
                               'SUN') THEN
UPDATE log_users
SET tipo = ('Fuera de horario'); END IF; END;