CREATE OR REPLACE TRIGGER hr_logon_trigger
  AFTER LOGON
  ON HR.SCHEMA
BEGIN
  IF to_char(to_date(sysdate,'dd/mm/yyyy'), 'DAY') = 'SATURDAY' THEN
  INSERT INTO log_users
              (
                          usuario,
                          tipo,
                          fecha
              )
              VALUES
              (
                          USER,
                          'FUERA DE HORARIO',
                          (
                                 SELECT to_char (sysdate, 'MM-DD-YYYY HH24:MI:SS')
                                 FROM   dual)
              );

  ELSIF to_char(to_date(sysdate,'dd/mm/yyyy'), 'DAY') = 'SUNDAY' THEN
  INSERT INTO log_users
              (
                          usuario,
                          tipo,
                          fecha
              )
              VALUES
              (
                          USER,
                          'FUERA DE HORARIO',
                          (
                                 SELECT to_char (sysdate, 'MM-DD-YYYY HH24:MI:SS')
                                 FROM   dual)
              );

  ELSIF to_char (sysdate, 'HH24:MI:SS') >= '20:00:00' THEN
  INSERT INTO log_users
              (
                          usuario,
                          tipo,
                          fecha
              )
              VALUES
              (
                          USER,
                          'FUERA DE HORARIO',
                          (
                                 SELECT to_char (sysdate, 'MM-DD-YYYY HH24:MI:SS')
                                 FROM   dual)
              );

  ELSIF to_char (sysdate, 'HH24:MI:SS') < '08:00:00' THEN
  INSERT INTO log_users
              (
                          usuario,
                          tipo,
                          fecha
              )
              VALUES
              (
                          USER,
                          'FUERA DE HORARIO',
                          (
                                 SELECT to_char (sysdate, 'MM-DD-YYYY HH24:MI:SS')
                                 FROM   dual)
              );

  ELSE
  INSERT INTO log_users
              (
                          usuario,
                          tipo,
                          fecha
              )
              VALUES
              (
                          USER,
                          'NORMAL',
                          (
                                 SELECT to_char (sysdate, 'MM-DD-YYYY HH24:MI:SS')
                                 FROM   dual)
              );

END
IF;
END;