Skip to Main Content

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!

SQL to avoid Dreaded "Divide by Zero" error

504701Dec 10 2008 — edited Dec 10 2008
Hey,

I have been banging my head off the decode and NVL functions to avoid the divide by zero error, can tfor the life of me get it.

2 columns, a & b.

Need to get: a/b (but the whole thing fails if either is null or zero)

Any help greatly appreciated.

Dob
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 7 2009
Added on Dec 10 2008
15 comments
2,712 views