Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Sqlldr and Oracle 10g

Sqlldr and Oracle 10g

From: rohan <amapola8_at_wp.pl>
Date: 18 Dec 2006 09:46:47 -0800
Message-ID: <1166464007.490869.47060@j72g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US