NVL(COUNT(*),0)

[rbragg]

In the following query, why would RECORD_COUNT still give me a null value instead of 0 if the db was empty?

 

<?php
$queryContract = "
SELECT action_num, status, NVL(COUNT(*),0) AS RECORD_COUNT
FROM schema.HEC_ACTION 
WHERE schema.HEC_ACTION.contract_num = '" . $_SESSION['contract'] . "'
AND schema.HEC_ACTION.step_num = '" . $thisStep . "'
GROUP BY action_num, status
ORDER BY action_num, status";
?>