Home -> Usenet -> comp.databases.oracle -> How to avoid divide by zero errors?

How to avoid divide by zero errors?

From: D. Alvarado <laredotornado_at_zipmail.com>
Date: 24 Mar 2002 17:00:59 -0800
Message-ID: <9fe1f2ad.0203241700.4d6b84c_at_posting.google.com> 






Hello,



I have a table with some columns,



COLUMN1   COLUMN2



-------   -------



4         2
3         0
5         1
10        0
15        30





I would like to execute the statement "SELECT COLUMN1 / COLUMN2 from
MY_TABLE", but if I execute this statement, I get divisor is equal to
zero errors.  However, I don't want to discount columns where the
divisor is equal to zero (e.g. "SELECT COLUMN1 / COLUMN2 from MY_TABLE
WHERE COLUMN2 > 0"), rather, I'd like the result of that column to be
a special number, say -1 or 0 or something.  For example, it would be
great if my result set looked like:



COLUMN1 / COLUMN2





2


-1



5


-1



.5



Can this be done?  How?



thanks, Dave A.
Received on Mon Mar 25 2002 - 02:00:59 CET












Original text of this message