title: Copying fields in Oracle
body: <p>I am not a programmer, but have a task of automatically copying one field in a table to another field in the same table (it's a long story... :-) ). This should be done on update and insert and I really do not know how to go about it.
  I should point out that data is entered to the DB through a user-interface which we do not have the source code for, and therefore we want to do this change on a DB level, using a trigger or  likes.
  I have tried creating a simple trigger that will copy the values across, but came up with an error message. After Googling the error, I found that I need to create a package which will be used as a variable. Now I am really lost!!!! :-)</p>
  
  <p>I want to also point out that I need a solution that will update this field automatically from now on, but not override any data that already exists in the column.</p>
  
  <p>Could someone show me the easiest and simplest way of doing this entire procedure? I really need a 'Guide for dummies' approach.</p>
  
  <p>Thanks,
  David</p>