Re: Divide by zero
From: deana strbevski <deana.strbevski_at_ina.hr>
Date: Fri, 23 Mar 2001 14:53:13 +0100
Message-ID: <3ABB5549.AA3247FB_at_ina.hr>
Date: Fri, 23 Mar 2001 14:53:13 +0100
Message-ID: <3ABB5549.AA3247FB_at_ina.hr>
try (DECODE(nvl(COST,0),0,null,BASE_SALE_UNIT_PRICE/COST))*100 Andy wrote:
> I would like to know why I cannot use a decode here to avoid a possible
> divide by zero in this sql statement:
> SELECT CATALOG_NO, CATALOG_DESC, QTY_SHIPPED, LINE_STATE,
> catalog_no,BASE_SALE_UNIT_PRICE,
> COST, REAL_SHIP_DATE,
> DECODE(((COST,0,NULL - BASE_SALE_UNIT_PRICE))/COST)*100
> AS GrossMargin
> FROM CUSTOMER_ORDER_JOIN
> WHERE LINE_STATE='Invoiced/Closed'
> Or LINE_STATE='Delivered'
Received on Fri Mar 23 2001 - 14:53:13 CET