Re: How to define the DecimalSeparator for SQL Loader Files

Robert Wehofer wrote:
> Hello!
>
> I would like to update datasets in an Oracle database by using SQL Loader
> files.
>
> One big problem of mine is how to know, which DecimalSeparator an SQL Loader
> file needs to treat floating numbers correctly.
>
> e.g.
> 71779.42|173686.93|
> or
> 71779,42|173686,93|
>
> Is there a possibility to upload floating numbers independent of country
> settings in Oracle? Perhaps the DecimalSeparator could be set in the CTL
> file but I don't find such a setting in the help file.
>
> Robert

Please look up

http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96529/ch3.htm#50651

-- 
Sybrand Bakker
Senior Oracle DBA