title: How do I alter a trigger in Oracle?
body: <p>I am trying to change the trigger script for my database. My trigger name is <code>ARCH_USER_UPD_TRG</code> and this puts any updates or deletes on the <code>USER</code> table into a <code>Z_USER</code> table</p>
  
  <p>I am dropping a column from the <code>USER</code> table and now need to modify the trigger script to no longer use this column.</p>
  
  <p>How do I modify the PL/SQL script of an oracle trigger?</p>