Re: SQLLoader : decimal with . or ,
From: Noud van Beek <ajb_at_dcmr.nl>
Date: Wed, 6 May 1998 08:12:35 +0200
Message-ID: <6iov0n$b7c$1_at_news.NL.net>
Date: Wed, 6 May 1998 08:12:35 +0200
Message-ID: <6iov0n$b7c$1_at_news.NL.net>
Olivier,
you have to set the registry entry NLS_NUMERIC_CHARACTERS on '.,' before starting sqlloader (if you use WIN 3.11 it's in ORACLE.INI)
regards
Noud van Beek
> 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
Received on Wed May 06 1998 - 08:12:35 CEST