title: Oracle trigger - update column on newly inserted record
body: <p>In My Oracle (Express) DB I have a table with a column, named <code>created</code>(date type).<br>
  What I am trying to do, is to create a trigger that will update that column after an update or insert, was done, with <code>SYSDATE</code>.</p>
  
  <p>My sql (for insert only, I know, it fails anyway) is:</p>
  
  <pre><code>CREATE OR REPLACE TRIGGER  "VIRTUAL_COUNTERS_NEW" 
  AFTER
  insert on "VIRTUAL_COUNTERS"
  begin
  new.updated := SYSDATE
  end;
  /
  ALTER TRIGGER  "VIRTUAL_COUNTERS_NEW" ENABLE
  /
  </code></pre>