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:03:08 +0100
Message-ID: <2v1pp0F2ft1mpU1@uni-berlin.de> 





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



Best Regards.



D.





"Mario King" <hliji_at_yahoo.com> ha scritto nel messaggio
news:a3f90977.0411050854.c45dcde_at_posting.google.com...


> 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

Received on Fri Nov 05 2004 - 11:03:08 CST












Original text of this message













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