Re: SQLPLUS divide by zero question

Thanks for the correction. That is what I meant. My eyes must have crossed!

Mungo Henning wrote:

> Shouldn't that be:
> select decode(sum(B),0,0,sum(A)/sum(B)) from table T;
> because if "sum(B)" matches "0" then you want to return something
> (I picked zero), otherwise you want to do the divide?
>
> Happy to be corrected...
> Mungo Henning :-)
>
> John P. Higgins wrote:
> >
> > select decode(sum(B),0,sum(A)/sum(B)) from table T;
> >
> > Iancrozier wrote:
> >
> > > I am trying to run a sql statement, something like this:
> > >
> > > select sum(A)/sum(B) from table T;
> > >
> > > Sometimes sum(B) is equal to zero. Is there any way in sqlplus I can run this
> > > or
> > > do I have to go to PL/SQL?
> > >
> > > Thanks in advance.
Received on Tue Aug 25 1998 - 08:40:56 CDT