Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Java - setFloat()
I want to store the RATE into table PO_HEADER.
But the table just store the value 123.123..
Why it cannot store 123.123456?
Please help me! Thank you!
Table PO_HEADER: // Using Oracel 8i
NUMBER(10,6) //size=10 ; scale=6
float zz=(float)123.123456;
pstmt=con.prepareStatement("insert into PO_HEADER (RATE) values (?)");
pstmt.setFloat(1,zz);
pstmt.executeUpdate();
Received on Wed Oct 31 2001 - 01:23:46 CST
![]() |
![]() |