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

Home -> Community -> Usenet -> c.d.o.server -> Re: 10g Bug with Numeric Precision/Scale?

Re: 10g Bug with Numeric Precision/Scale?

From: James Carr <drjamescarr_at_gmail.com>
Date: 7 Sep 2005 09:10:03 -0700
Message-ID: <1126109403.115281.29820@g44g2000cwa.googlegroups.com>


I've found a 10.1.0.4.0 machine

SQL> select * from v$version;

BANNER



Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bi PL/SQL Release 10.1.0.4.0 - Production
CORE 10.1.0.4.0 Production
TNS for Solaris: Version 10.1.0.4.0 - Production NLSRTL Version 10.1.0.4.0 - Production

I still get the same strange behaviour as on 10.1.0.3

1.23100007
1.23
1.23
1.231
1.23100007
1.23100007
1.23100007
1.231

Daniel, when you tried it on 10.1.0.4.0 how did you get the correct answer?

~
James Received on Wed Sep 07 2005 - 11:10:03 CDT

Original text of this message

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