First thanks for you reply
Here is my control file
LOAD DATA
infile *
replace into table testnum
fields terminated by ","
(nb1 , nb2)
begindata
12 14
12.5 13.4
12 5.17
13 14.55
So, if i change all dots with coma SQL*loader works normally
(In france we use comma instead of dot)
But my NLS_LANGUAGE is AMERICAN so I dont understand for which reason it
doesn't work
Excuse my Bad english :)
"damorgan" <dan.morgan_at_ci.seattle.wa.us> a écrit dans le message news:
3C681223.DF631C3E_at_ci.seattle.wa.us...
> I fail to see the issue. Could you perhaps explain what it is? I would
> have no problem loading the following three values into a column in a
> table with SQL Loader.
>
> Daniel Morgan
>
>
>
> ben moh wrote:
>
> > How to load a column number containing data like this
> >
> > 12.5
> > 13.4
> > 11.78
> >
> > Oracle needs "," (comma) instead off "." (dot)
>
Received on Tue Feb 12 2002 - 10:53:57 CST