Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.glorb.com!news.cs.univ-paris8.fr!proxad.net!newsfeed.tpinternet.pl!atlantis.news.tpi.pl!news.tpi.pl!not-for-mail From: "TomekS" Newsgroups: comp.databases.oracle.server Subject: FLOAT(0) Date: Wed, 3 Mar 2004 08:56:45 +0100 Organization: tp.internet - http://www.tpi.pl/ Lines: 13 Message-ID: NNTP-Posting-Host: 213.25.190.130 X-Trace: nemesis.news.tpi.pl 1078300994 18864 213.25.190.130 (3 Mar 2004 08:03:14 GMT) X-Complaints-To: usenet@tpi.pl NNTP-Posting-Date: Wed, 3 Mar 2004 08:03:14 +0000 (UTC) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:256177 Hi Is FLOAT(0) datatype possible in 9.2.0.4 database? I'm asking because I've got a problem with database after upgrade from 8.1.7 to 9204 - all NUMBER columns are FLOAT(0) now. Some selects are not working properly with CBO and working fine with RBO. please help -- TomekS