title: How to get cout(*) based on sysdate -1
body: <p>I want to get count(*) with table name printed with records which are sysdate-1 in oracle.</p>
  <p>Select abc , count(*) from abc where dat_last_mnt &lt; sysdate -1</p>
  <p>With regards
  Sree</p>