title: Oracle: SELECT where date is less if not equals null
body: <p>I have a table of records, and one column holds the value when the records turns in-active.
  Most of the records are still open, and therefore do not hold any value in the <code>end_date</code> column.</p>
  
  <p>I want to select all of those records, which are still active. One way to achieve this (from the top of my head):</p>
  
  <pre><code>select *
  from table t
  where nvl(t.end_date, to_date('2099-DEC-31', 'MM-DD-yyyy')) &gt; sysdate
  </code></pre>
  
  <p>But it doesn't feel right. Is there a better way to achieve what I want?</p>
  
  <p>EDIT: BTW, the table isn't huge, and isn't going to grow :)</p>