Re: sqlldr and decimal delimiters

From: Richard Kuhler <noone_at_nowhere.com>
Date: Thu, 13 Mar 2003 17:29:33 GMT
Message-ID: <1e3ca.36$UE.283824@twister.socal.rr.com>

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?
Received on Thu Mar 13 2003 - 11:29:33 CST