title: PLSQL is it possible to update a table column on a certain date?
body: <p>I have this table : </p>
  
  <pre><code>penalities(player,dateofpenality,penalityDays,status)
  </code></pre>
  
  <p>Based on certain criteria a player is added to this table where the status goes to 'yes'. I want his status to change to 'no' jusrt after the penality period (=penalityDays) is gone.</p>
  
  <p>I thought of a trigger on date but I couldn't find it in plsql.
  Please note that I don't want to delete the player as I need the history .</p>