Steve,
It's an old bug. The workaround is to round the
number to a precision of 38 before truncating it:
SQLWKS> select trunc(round(log(2,4),38)) from dual;
TRUNC(ROUN
1
HTH,
- Anita
- Steve Adams <steve.adams_at_ixora.com.au> wrote:
> Hi All,
>
> Oracle 8.1.6 appears to think that ... trunc(log(2,
> 4)) = 1.
>
> SQL> select trunc(log(2,4)) from dual;
>
> TRUNC(LOG(2,4))
> ---------------
> 1
>
> Does it reproduce on earlier versions?
>
> Regards,
> Steve Adams
> http://www.ixora.com.au/
> http://www.oreilly.com/catalog/orinternals/
> http://www.christianity.net.au/
>
> --
> Author: Steve Adams
> INET: steve.adams_at_ixora.com.au
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Get Yahoo! Mail – Free email you can access from anywhere!
Received on Wed Jul 12 2000 - 01:17:51 CDT