title: INSERT TRIGGER IN ORACLE
body: <p>I am new to triggers in Oracle. I created an EVENT table with this syntax:</p>
  
  <pre><code>CREATE TABLE Event
  (event_id NUMBER (3) NOT NULL,
   event_date DATE NOT NULL,
   venue_id NUMBER (2) NOT NULL,
   concert_id NUMBER (3) NOT NULL
  );
  </code></pre>
  
  <p>I want to create a trigger to ensure that concerts cannot run during the month of August. I tried the following code to create the trigger. The trigger was created successfully but after inserting a date with the month of August, it was inserted. This is not suppose to be. </p>
  
  <pre><code>CREATE OR REPLACE TRIGGER check_date
    BEFORE INSERT ON event
  DECLARE 
    event_date date;
  BEGIN
    IF (to_char(event_date, 'mm') = 8) THEN
      raise_application_error(-20000, 'Concerts cannot be run during August');
    END IF;
  END;
  </code></pre>