Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!news.tele.dk!news.tele.dk!small.news.tele.dk!fr.ip.ndsoftware.net!nerim.net!news.tiscali.fr!not-for-mail
From: "_ Polux" <CABOTpolux62@ifrance.com>
Newsgroups: comp.databases.oracle.server
Subject: sqlloader and numeric separator
Date: Thu, 9 Sep 2004 23:01:57 +0200
Organization: Guest of TISCALI - FRANCE
Lines: 16
Message-ID: <chqg2b$jsv$1@news.tiscali.fr>
NNTP-Posting-Host: 213.36.131.158
X-Trace: news.tiscali.fr 1094763403 20383 213.36.131.158 (9 Sep 2004 20:56:43 GMT)
X-Complaints-To: abuse@libertysurf.fr
NNTP-Posting-Date: Thu, 9 Sep 2004 20:56:43 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4927.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:224621

Hi,

I've got a flat file.
I need to load this file in a table by SQLLOADER.

There are numerics fields in this file with coma as numeric separator.
Oracle needs point as numeric separator.

Is there a parameter in the control file to convert the coma ?

Thanks .
Yo

Oracle 7.3.4 and unix tru64