Skip to Main Content
Forums

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!

divisor is equal to zero

syed haiderAug 29 2018 — edited Aug 29 2018

I'm getting an error message "divisor is equal to zero'

following is my code snippet;

select

nvl(total_records,0)/nvl(l2y_sum_ees,1)

from emp

column l2y_sum_ees has some nulls in there. I'm taking care of the nulls in my formula. I don't understand that why I'm still getting this error. How else could I specify to replace null with 1 for the divisor.

Thanks in advance
This post has been answered by jaramill on Aug 29 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 26 2018
Added on Aug 29 2018
#oracle, #sql
6 comments
12,652 views