Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> sqlldr load numbers changing decimal
Hello,
I am trying to load a text file with numbers containing a . as a decimal. The only problem is only comma , is accepted as a decimal on my server.
1;0;0;2004-02-27 00:00:00;3;0;N;;2004-02-27 00:00:00;; 1;1990;2;2003-01-09 00:00:00;5;0;N;1513.2527515762899;;;
my ctl:
LOAD DATA
INFILE 'D:\fnbhistoho.txt'
INTO TABLE "USER"."FINANCIALNUMBERHISTOHOLLOW"
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
(FINANCIAL_NUMBER_SET_ID, FISCAL_YEAR, PERIOD_TYPE_ID, DATE_ORA DATE
"YYYY-MM-DD HH24:MI:SS", NUMBER_TYPE_ID, IS_WIP, IS_ESTIMATED, NUMBER_VALUE,
NUMBER_DATE_VALUE DATE "YYYY-MM-DD HH24:MI:SS", NUMBER_STRING_VALUE,
NUMBER_INT_VALUE )
the command line:
sqlldr user/pass_at_server control=D:\testrun.ctl log=D:\log.txt
If anyone could help...
thanks in advance
Received on Thu Nov 18 2004 - 09:47:31 CST