title: Automate tasks in Oracle11g
body: <p>I am creating a database for an auction in which I have a table that stores the entries of Items that are put up for auction.<br></p>
  
  <pre><code>create table items(
  item_ID number(5) PRIMARY KEY,
  SDate DATE NOT NULL,
  EDate DATE NOT NULL, //end date for auction
  minBid number(5,2) NOT NULL,
  bidInc number(2,2) NOT NULL,
  title varchar2(20) NOT NULL,
  descr varchar2(255),
  currentBid number(5,2)
  )
  </code></pre>
  
  <p>Now after the end date has passed I want the database to automatically delete that entry from the table.<br>
  How do I do it?</p>