title: Date comparison in Oracle 11g
body: <p>I'm new to Oracle 11g &amp; I have a question about a query. </p>
  
  <p>I have a table <code>dummy</code> which has <code>created_date</code> column of type <code>Date</code>.</p>
  
  <p>I want a query which will return all the records where <code>created_date</code> + 7 days is less than today's date.</p>
  
  <p>What type of query in Oracle 11g accomplishes this?</p>