title: how to set a null value to default in oracle sql
body: <p>How do I set an empty set or null value to a default value like 1? </p>
  
  <p>So far, I have this statement, but in case I get null values i want to handle that:</p>
  
  <pre><code>select case when count(*)=0 
                     then 0 
                   else 1 
                     end OUTPUT 
  from TESTTBL 
  where timestamp = to_char(sysdate-1, 'yyyymmdd')||'0000';
  </code></pre>