Re: sqlldr

From: Prem K Mehrotra <premmehrotra_at_hotmail.com>
Date: 29 Aug 2004 19:17:04 -0700
Message-ID: <43441e77.0408291817.914718c@posting.google.com>

rallykarro_at_hotmail.com (karolina) wrote in message news:<c8a98246.0408291356.4474d762_at_posting.google.com>...
> Hi,
>
> I have a text file descibing 3 columns in the format of:
> car1;volvo;1234,34
> car2;saab;4567,34
> .
> .
>
> I want to load this into a table in oracle with sqlldr. The last
> colomn in the text file is the price with decimals. The last column in
> my table is a number(10,2) and as I understand oracle does not accept
> a decimal number if the decimals are separated with a ,(comma) instead
> of a .(dot)
> How can I in my control file make it work when inserting the price?
> Do I have to convert the price before insert and how do I do that?
>
> thanks
>
> Karolina

Search for NLS_NUMERIC_CHARACTERS on google. You can set this env variable, so Oracle interprets , as . This parameter is part of Multi-Lingual support
of Oracle.

http://www-rohan.sdsu.edu/doc/oracle/server803/A54645_01/ch4.htm#13930 Received on Sun Aug 29 2004 - 21:17:04 CDT