Hi Manasa,
Your query prevents nulls, but it does not prevent zeroes.
(In Oracle, Null is not the same as zero)
Regards,
J Trifts


-----Original Message-----
From: Manasa [mailto:oracledba-ezmlmshield-x5392833.[Email address protected]

Sent: Thursday, May 11, 2006 2:28 PM
To: LazyDBA Discussion
Subject: Sql error - ORA-01476: divisor is equal to zero


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



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


*** Confidentiality Notice *** Proprietary/Confidential
Information belonging to CGI Group Inc. and its affiliates
may be contained in this message. If you are not a recipient
indicated or intended in this message (or responsible for
delivery of this message to such person), or you think for
any reason that this message may have been addressed to you
in error, you may not use or copy or deliver this message
to anyone else. In such case, you should destroy this
message and are asked to notify the sender by reply email.

Oracle LazyDBA home page