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

Jaap W. van Dijk wrote:

> 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.
>

You don't really need to change the characterset but only to specify the language_territory.

> 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.
>

First example I found:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14223/transform.htm (official documentation).

Hope it can help.

-- 
Fabrizio Magni

fabrizio.magni_at_mycontinent.com

replace mycontinent with europe