Re: How to avoid divide by zero errors?

Use DECODE...

SELECT DECODE(column2,0,-1,column1/column2) AS my_calc FROM my_table;

If there's a chance of column2 being NULL, then:- SELECT DECODE(NVL(column2,0),0,-1,column1/column2) AS my_calc FROM my_table;

This is the cleanest way. Don't use the previous union example as this will require two scans of the table then a sort and merge...

Regards

Adrian Received on Tue Mar 26 2002 - 09:49:01 CET