Problem with Oracle float type

Hi all,

I got a problem when insert data to a column with float data type, here is my steps.

1. create table m_test (a float);
2. insert into m_test values(2.2999999999999998);
3. select * from m_test;

this is what I got

         A

       2.3

I dont want Oracle server displays this value to me, I need the value 2.2999999999999998, which has been inserted. I believe that the 2.2999999999999998 has been stored in the database. because if you do select * from m_test where a=2.3, you get nothing. It looks weird. Does anybody have idea?

I am running Oracle 8.1.6 on NT.

thank you in advance.

daning

Sent via Deja.com
http://www.deja.com/ Received on Wed Dec 27 2000 - 19:07:27 CST