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: Divisor is equal to zero

Re: Divisor is equal to zero

From: Mladen Gogala <mgogala.spam-me-not_at_verizon.net>
Date: Thu, 21 Sep 2006 02:59:39 GMT
Message-Id: <pan.2006.09.21.02.59.38.884278@verizon.net>


On Wed, 20 Sep 2006 10:28:34 -0700, muddu wrote:

> Hello,
>
> I am running a sql script to determine how much % the tablespaces are
> occupying.
> But I am getting this error:
>
> ERROR at line 3:
> ORA-01476: divisor is equal to zero
>
> line 3: round(100 * (us.usedspace / df.totalspace)) per.
>

Chuck Norris can divide by zero.

-- 
http://www.mgogala.com
Received on Wed Sep 20 2006 - 21:59:39 CDT

Original text of this message

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