Re: Limit or Bug?

From: "Jared Still" <jkstill@xxxxxxxxx>
To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 7 Jul 2008 11:49:55 -0700

On Thu, Jul 3, 2008 at 1:44 PM, Jared Still <jkstill@xxxxxxxxx> wrote:

>
> The following bit of SQL uses the mod() function to determine modulus 2 of
> two large numbers
>
> 13:37:20 SQL>set echo on
> 13:37:24 SQL>@mod_test
> 13:37:25 SQL>
> 13:37:25 SQL>
> 13:37:25 SQL>
> 13:37:25 SQL>select mod(power(2,127)-1,2) from dual
> 13:37:25   2  /
>
>
Question was answered on OTN forums.

http://forums.oracle.com/forums/thread.jspa?threadID=678729

It's in the docs - scale is limited to a range of -84 to 127

*http://tinyurl.com/6qllqu


*--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

References:

Limit or Bug?
From: Jared Still

Re: Limit or Bug?

Other related posts: