float value being rounded by sql loader [message #71887] |
Tue, 28 January 2003 15:51 |
jinga
Messages: 116 Registered: January 2003
|
Senior Member |
|
|
My data file has these values.
190856321
88087533
My table has one column which is float(16).This is where i want to load my flat file.
SQLloader loads the record but changes the value to
190860000. Why is it rounding the value???
|
|
|
|
Re: float value being rounded by sql loader [message #71890 is a reply to message #71888] |
Wed, 29 January 2003 08:03 |
jinga
Messages: 116 Registered: January 2003
|
Senior Member |
|
|
Here is my control file. I just have one column in the table which is float(16).I need not have written fields terminated by "," as there is only one value.If i remove the line, the result is even worse.After sqlldr completes its job when i look at the table it has only one digit. When i put fields terminated by, I get the rounded value..
load data
infile 'abc.txt'
insert into table estimation.test_anu1
fields terminated by ","
(iw)
This is my flat file
190856321
88087533
|
|
|
|
|