Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP- How to ignore Divide by Zero error in database

Re: HELP- How to ignore Divide by Zero error in database

From: Davide Semprini <d.semprini_at_webconsulting.it>
Date: Fri, 5 Nov 2004 18:24:11 +0100
Message-ID: <2v1r0fF2g17fbU1@uni-berlin.de> 





Sorry,


It was a mistake, DECODE() or CASE to test 0!



D.



"Bricklen" <bricklen_at_zyahoo.zcomz> ha scritto nel messaggio
news:ynOid.82116$df2.24975_at_edtnps89...


> Davide Semprini wrote:

> > You can prevent it use NVL() function test if a divisor is 0!

> >

> > Best Regards.

> >

> > D.

> >

> How so? Zero is not a null value.

Received on Fri Nov 05 2004 - 11:24:11 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US