Skip to Main Content

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!

Sql Bugs In MOD Function

41a21c01-c68a-4e3e-b8bb-9ebe4295239aApr 9 2017 — edited Apr 10 2017

when write

Select mod(sal,comm)

from emp

where comm is not null;

we will find that the result of the mod(sal,comm) when comm = 0 is the same value

and this itself a big mathematical issues

(the problem in sql not in sql developer software because i tried it on online oracle work space also)

i am leaving you with the picture

thanks

feedBack.PNGFeedBack2.PNG

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 8 2017
Added on Apr 9 2017
7 comments
748 views