Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQLPLUS divide by zero question

SQLPLUS divide by zero question

From: Iancrozier <iancrozier_at_aol.com>
Date: 24 Aug 1998 22:56:29 GMT
Message-ID: <1998082422562900.SAA14651@ladder03.news.aol.com>


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 Mon Aug 24 1998 - 17:56:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US