Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL LDR and FLOAT field
Hi,
I am desperatly trying to load a simple csv file into an empty table (may be
not that simple after all!).
It keeps on telling the numbers are invalid for the colun value.
When I get rid of the digits after the comma it works fine. Would there be a
way to load big numbers with sqlldr?
(It also does not work with the datatype NUMBER, same message).
Thanks for helping.
here is my ctl file
LOAD DATA
INFILE 'C:\loadCSV\testrun.csv'
INTO TABLE STOCK_DATA
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(CODE, NBTYPE, YEAR, PERIOD, IS_ESTIMATE, VALUE )
The structure of my table:
CREATE TABLE OWNER.STOCK_DATA
(
CODE VARCHAR2(10) NOT NULL, NBTYPE VARCHAR2(10) NOT NULL, YEAR NUMBER(10) NOT NULL, PERIOD VARCHAR2(2) NOT NULL, IS_ESTIMATE VARCHAR2(2) NOT NULL, VALUE FLOAT(126) NOT NULL
Here is what looks like my csv file:
SIEGn.DE,DBFI058,1989,A,N,10684.102654 SIEGn.DE,DBGE001,1989,A,N,370000.000000 SIEGn.DE,DBGE002,1989,A,N,365000.000000 SIEGn.DE,DBIA001,1989,A,N,18693.802631 SIEGn.DE,DBIA002,1989,A,N,11586.385320 SIEGn.DE,DBIA003,1989,A,N,6335.300000 SIEGn.DE,DBIA004,1989,A,N,2797.500000 SIEGn.DE,DBIA005,1989,A,N,4768.400000 SIEGn.DE,DBIA008,1989,A,N,7107.417311Received on Thu Mar 18 2004 - 06:28:19 CST