title: Creating a INSERT TRIGGER in different table
body: <p>I need help on creating a trigger on my table1
  that will insert specific columns into table2 from table1.
  How can i do that? I am using Oracle 11G XE .</p>
  
  <p>Here is my code:</p>
  
  <pre><code>create trigger AllowanceTrigger
  on ex_bulacan
  after insert
  as
  insert into allowance VALUES (PLANT_ORIGIN,SO_NO, SO_STATUS,SO_REMARKS,DRIVER_NAME)
      select plant_origin, sales_order_no, status,remarks, driver_name
      from ex_bulacan;
  go ; 
  </code></pre>
  
  <p>When I run that command I get this error</p>
  
  <pre><code>ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyword
  </code></pre>
  
  <p>The explanation is:</p>
  
  <blockquote>
    <p>ORA-04071. 00000 -  "missing BEFORE, AFTER or INSTEAD OF keyword"<br>
    *Cause:    The trigger statement is missing the BEFORE/AFTER/INSTEAD OF clause.<br>
    *Action:   Specify either BEFORE, AFTER or INSTEAD OF.</p>
  </blockquote>