Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> SQLPLUS divide by zero question
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
![]() |
![]() |