title: Oracle Trigger update column with information from another column in the same table
body: <p>I need to create a trigger in the yyy table. After a insert, I must update the test1 column with the same information of test2 column.</p>
  
  <p>Could be like this?</p>
  
  <pre><code>CREATE OR REPLACE TRIGGER TRG_update
  
  AFTER INSERT ON yyy FOR EACH ROW
  
  BEGIN
  
  UPDATE yyy SET TEST1 = :NEW.TEST2
  
  END
  </code></pre>