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: Bricklen <bricklen_at_zyahoo.zcomz>
Date: Fri, 05 Nov 2004 16:59:41 GMT
Message-ID: <1kOid.82113$df2.31622@edtnps89> 





Mario King wrote:


> Hi,

> 

> User's SQL script generated "ORA-01476: divisor is equal to zero".

> How to make database to ignore this error and script to continue?

> 

> Thanks in advance.

> 

> MK



decode or case statements may be of use here.
eg. case when div=0 then 1 else div end
Received on Fri Nov 05 2004 - 10:59:41 CST












Original text of this message













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