title: Is there a BEFORE SELECT trigger in pl/sql?
body: <p>Hi I am using sqldeveloper conected to an oracle database.</p>
  
  <p>My senario is I have a customer table in my database with a date field called <code>start_date</code> which holds the date of the day the user signed up and a "boolean" field called <code>is_member</code>. Each membership only lasts one year so <code>is_member</code> is false if <code>SYSDATE &gt; start_date + 1year</code>.</p>
  
  <p>I would like to do a check to see if a user is still a member (and change <code>is_member</code> if not) before the user calls a select statement. Is this possible?</p>
  
  <p>If not has anyone got any ideas on how else to keep the <code>is_member</code> field up to date? Can you do a trigger that is called once a day to see if the membership has expiered?</p>
  
  <p>Thanks in advace! =]</p>