SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Divide by ZERO error.

798631Oct 8 2010 — edited Oct 8 2010

Hello,
I Need a little help. I keep getting divsor is equal to 0 error in both pl/sql devloper and oracle report builder 6i
In reports builder i have a Formula column with the following:

return ((:a - :b)/:a) *100;

Whats a simple way to get around the divide by 0 error?
Thanks.

This post has been answered by Hoek on Oct 8 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 5 2010

Added on Oct 8 2010

#6i, #error, #oracle, #plsql, #reports, #sql

9 comments

2,313 views