ThankYou!!!! ThankYou!!! forgot the major fact.

Regards,
Manasa.

-----Original Message-----
>From: Jonathan <oracledba-ezmlmshield-x96705816.[Email address protected]
>Sent: May 11, 2006 9:34 AM
>To: LazyDBA Discussion <[Email address protected]
>Subject: RE: Sql error - ORA-01476: divisor is equal to zero
>
>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.
>
>
>--------
>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
>


Oracle LazyDBA home page