SQL Language (MOSC)

MOSC Banner

Query execution with mod results zero

edited Feb 20, 2013 7:27PM in SQL Language (MOSC) 5 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center