SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Division by zero Error.

Lucy DiscoverDec 9 2010 — edited Dec 15 2010

hi all,
I am getting division by zero error in one of the Reports that was developed by one of our programmers. I think this can be easily rectified by decoding or using a Case statement. I am just not sure about how to use it in below scenario.

SUM( round((nvl("TRIP"."DRY_MAT",0))  
 / nvl("TRIP"."SPREAD_MILES",1) * 2000,2) ) over(partition by "TRIP"."TRIP_NO",

Edited by: Lucy Discover on Dec 15, 2010 12:41 PM

This post has been answered by isotope on Dec 15 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 12 2011

Added on Dec 9 2010

12 comments

998 views