Query execution with mod results zero
Hi,
When below query is executing, mod more than 40 digits returning 0 and mod of 39 digits returning the correct value.
Can any one help me out on this?
Wrong output:
SQL> SELECT mod(power(10,44),100) FROM dual;
MOD(POWER(10,44),100)
---------------------
0
Correct :
SQL> SELECT mod(power(10,39),97) FROM dual;
MOD(POWER(10,39),97)
--------------------
77
Regards,
Sriram
0