Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Sqlldr and Oracle 10g
I wanted to load data by means of sqlldr (fields terminated by ",")
The data are as follows :
Id Descriptiion Price
1, Stuff,2.45
2, Stuf,3.77
..
..
3000,Stuff,06
But it turned out to be that sqlldr can't load float number ( only
integer -1,2,3......)
But when I use instruction : insert into Table values(1,'Stuff1',2.45)
- it's works all right and record is saved.
The column Pirice has a number type. Is it necessary to add some more
options in order to load float numbers ?
PIotr W. Received on Mon Dec 18 2006 - 11:46:47 CST