title: TRIGGER with INSERT AND UPDATE
body: <p>I need help on creating a trigger on my <code>table1</code> that will insert specific columns into <code>table2</code> from <code>table1</code>. How can I do that? I am using Oracle 11G XE .</p>
  
  <p>Here is my code:</p>
  
  <pre><code>create or replace trigger AllowanceTrigger
  after insert on ex_bulacan
  for each row
  begin
      insert into allowance (PLANT_ORIGIN,SO_NO, SO_STATUS,SO_REMARKS,DRIVER_NAME)
      values (:new.plant_origin, :new.sales_order_no, :new.status,:new.remarks, :new.driver_name);
  end; ​
  </code></pre>
  
  <p>What if they update the data in <code>ex_bulacan</code>? Will automatically change my <code>allowance</code> table as well? </p>