SQL to avoid Dreaded "Divide by Zero" error
504701Dec 10 2008 — edited Dec 10 2008Hey,
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