SQLLoader : decimal with . or ,
From: Olivier ERTZ <ertz_at_illite.u-strasbg.fr>
Date: Tue, 05 May 1998 16:36:55 +0200
Message-ID: <354F2407.283A5D39_at_illite.u-strasbg.fr>
Hello,
Date: Tue, 05 May 1998 16:36:55 +0200
Message-ID: <354F2407.283A5D39_at_illite.u-strasbg.fr>
Hello,
[Quoted] i have a text file (in fact a .csv from Excel) with decimal number
like 54.65 and not 54,65.
sqlloader seems to make a difference between the point and the comma
with the comma, it works
with the point, it doesn't work, but i want to load files with
points
is there a solution that permits to load decimal point formed ?
Thank you for answering
--
------------------------------ ERTZ Olivier -------------------------
Etudiant en Maîtrise Informatique | Vacataire du CGS - EOST
UFR de Mathematique et Informatique | Centre de Géochimie de la Surface
67000 STRASBOURG - FRANCE | 1, rue Blessig - 67084 Strasbourg
--> ertz_at_pascal.u-strasbg.fr <-- | --> ertz_at_illite.u-strasbg.fr <--
-----------------------------------------------------------------------
...zORgLUb \|/ ____ \|/
_at_~/ ,. \~@
/_( \ _/ )_\ la revanche...
\_U__/
Received on Tue May 05 1998 - 16:36:55 CEST
