title: How to show 0 when no row found
body: <p>I have a SQL query in which I am passing sysdate to the query problem is that when there is no matching date in table with sysdate then it don't shows the zero even if there is nvl applied
   here is my query </p>
  
  <pre><code>select * from molasses
  where trunc(trn_dte) = trunc(sysdate)
  </code></pre>
  
  <p>But it show data only when current date is present in table but I want to show zero if no data found in table.please help me to do this in oracle 10 g. Because some times the situation is like above and I have to display zero when no data found</p>