Re: Limit or Bug?

On Thu, Jul 3, 2008 at 1:44 PM, Jared Still <jkstill_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l