Re: sqlldr and decimal delimiters

From: Christoph Seidel <christoph.seidel1_at_gmx.de>
Date: Thu, 13 Mar 2003 17:43:58 +0100
Message-ID: <b4qcj0$221878$1@ID-143718.news.dfncis.de>

EpiteamB wrote:
> I'm not sure, but I don't think so...
> You should use "DECIMAL EXTERNAL" with POSITION to declare the field
> in the controlfile for sqlldr,

this is no problem, the problem ist the character for the decimal delimiter.

> and use SQL functions such as DECODE, SUBSTR, TO_NUMBER ... to make

well, TO_NUMBER uses the NLS settings, one could use "alter session" to change this, but how to with sqlldr?

I want to be independend of nls settings, that is the prob (also with decode & co). Received on Thu Mar 13 2003 - 10:43:58 CST