title: Oracle Query - Select row having end_date (may be NULL/EMPTY) greater than sysdate
body: <p>I have Oracle table <code>Demo_t</code>, having column <code>end_date</code> which may have value null. I want to select all rows having <code>end_date</code> greater than current date.</p>
  
  <p>I have written query below</p>
  
  <pre><code>select * from Demo_t where NVL(End_date,sysdate+3) &gt; sysdate;
  </code></pre>
  
  <p>No doubt, query is giving expected result but I want make sure that i am not missing something or that any other better solution exists. It will help me to better understand Oracle database more.</p>
  
  <p>Thanks,</p>