Following query is giving me the divisor is equal to zero error even though I have this criteria in the where clause- AND (pre_reg_occur IS NOT NULL AND subm_occur IS NOT NULL)

What am I missing here. Appreciate any suggestions.

ThankYou,
Manasa.


SELECT 'B',
W.TITLE, value_string, SUM(pre_reg_dur + subm_dur)/ SUM(pre_reg_occur + subm_occur)
FROM L,
S,
SAV,
W
WHERE l.SCRIPT_ID IN (SELECT ID FROM S WHERE ROWNUM < 521 ) AND
L.SCRIPT_ID = s.ID
AND sav.SCRIPT_ID = S.ID
AND sav.ws_id = w.ID
AND s.ws_id = w.ID
AND w.ID = 4
AND sav.ATTR_TYPE_ID IN ( SELECT ID FROM ATTR_TYPE WHERE KEY = 'script.submitters')
AND l.active_cycle ='T'
AND (pre_reg_occur IS NOT NULL AND subm_occur IS NOT NULL)
GROUP BY W.TITLE, sav.value_string


Oracle LazyDBA home page