Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Odd math

Re: Odd math

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Tue, 11 Jul 2000 23:17:51 -0700 (PDT)
Message-Id: <10555.111759@fatcity.com>


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,


Do You Yahoo!?
Get Yahoo! Mail – Free email you can access from anywhere! Received on Wed Jul 12 2000 - 01:17:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US