Alternative for null divisor in calculation

[posiedon]

Hi

i am using oracle 8.1.7.2 and need to have an alternative within a select statement.

I am calculating the percentage failure from some data
(failure/attempts) * 100

there is the potential for the attempts to = 0, so this will potentially produce an error in the select statement.

how do i say:
if attempts = 0, then the percentage is 0??

thanks

Stephen

 

[grega]

Depending on how you're doing it, you could use the case statement (if Oracle supports it!) ... something like

select percentage = case attempts
when 0 then 0
else (failure/attempts) * 100
end
from tablename

Greg.

 

[angiole]

Oracle supports CASE as follows:

select failure,
attempts,
(case when attempts = 0
then 0
else (failure/attempts)*100 end)pct
from table1
...


AA :~)