Re: Divisor is equal to zero

Hello,

muddu wrote:
> ERROR at line 3:
> ORA-01476: divisor is equal to zero
>
> line 3: round(100 * (us.usedspace / df.totalspace)) per.

just in case you didn't find out yet:

You can catch 0 values with decode(). This can be used similar to "if ... then ..." constructs in procedural language. Not very elegant but works.

There was a discussion on decode some threads earlier.

Greetings Roman Received on Thu Sep 21 2006 - 02:44:16 CDT