OraFAQ Forum: Server Utilities » float value being rounded by sql loader

Home » RDBMS Server » Server Utilities » float value being rounded by sql loader

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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???

Report message to a moderator

Re: float value being rounded by sql loader [message #71888 is a reply to message #71887]

Wed, 29 January 2003 05:54

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

can you post the control file?

Report message to a moderator

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

Report message to a moderator

Re: float value being rounded by sql loader [message #71892 is a reply to message #71888]

Wed, 29 January 2003 08:42

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

issue is not with sql*loader.
even if u just insert , u will get the same.
Look into the documentation for details about USING FLOAT Datatype.

mag@itloaner1_local > insert into test211 values (190856321);

1 row created.

mag@itloaner1_local > insert into test211 values (88087533);

1 row created.

mag@itloaner1_local > select * from test211;

         N
----------
 190860000
  88088000

Report message to a moderator

Re: float value being rounded by sql loader [message #71894 is a reply to message #71888]

Wed, 29 January 2003 10:11

jinga
Messages: 116
Registered: January 2003

Senior Member

Yes.We plan to change the data type to number.Thanks a lot.

Report message to a moderator

Previous Topic:	query option use in the export utility
Next Topic:	exp80 error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 17:08:24 CDT 2024