Re: Limit or Bug?

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 7 Jul 2008 11:49:55 -0700
Message-ID: <bf46380807071149u4640cdfeo92c0eb79e78ecddd@mail.gmail.com>


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
Received on Mon Jul 07 2008 - 13:49:55 CDT

Original text of this message