Re: How do I change the interpreted decimal character in an external table file

On Tue, 30 Aug 2005 18:37:21 GMT, Fabrizio <fabrizio.magni_at_mycontinent.com> wrote:

>Jaap W. van Dijk wrote:
>> Doug, I'm not looking for the handling of delimiter characters BETWEEN
>> fields, but the handling of a comma as a decimal point WITHIN a field.
>> So if a fields contains
>>
>> 12,345
>>
>> I want Oracle to interpret this as 12 units and 345thousandths of a
>> unit, and NOT twelve thousand three hundred and fourtyfive or error on
>> this value.
>>
>
>You can specify the CHARACTERSET in the table creation DDL.
>
>For example if you specify italian you'll find your delimiter for that
>table is the comma.
>The american has the point.
>
>Maybe there is a better way to achieve the same result... but personally
>I use this one when dealing with external tables.

Fabrizio,

Thank you for the pointer, I'll try it myself. I think It's a bit tricky though because all sorts of reinterpretations could take place, not only the decimal character.

Do you know where this is documented, because all I can find is that you have to adjust this by specifying another NLS_TERRITORY or NLS_DECIMAL_CHARACTERS. Jaap. Received on Tue Aug 30 2005 - 15:59:46 CDT