title: Oracle SQL Saying NULL instead of 0 (ZERO)
body: <p>I have a query where it is subtracting from two columns and then dividing to generate a percentage complete. If the area hasn't been started it propduces NULL I would like it to instead show 00 or 0.</p>
  
  <p>Here is my Query:</p>
  
  <pre><code>substr(count(process_locations.count_attempt_id)/count(processes.process_id),2,2) as "Percentage Complete"
  </code></pre>
  
  <p>I have try NVL, and COALESE, but am unsure where to place them I have tried a few combinations, but i Receive errors.</p>
  
  <p>I have also tried a CASE WHEN ELSE END, but it still said null.</p>