Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlldr and decimal delimiters
Richard Kuhler wrote:
> You can use TO_NUMBER and override the NLS parameters for the function
> ...
>
> select to_number(
> '1234,56',
> '9999D99',
> 'NLS_NUMERIC_CHARACTERS = '',.''')
> from dual
>
>
> Richard
>
> Christoph Seidel wrote:
>>
>> hi,
>>
>> is there a way how i can set the decimal delimiter for sqlldr?
well, it works :) thanx alot! Received on Thu Mar 13 2003 - 11:43:25 CST